package aitsm;

import javax.swing.ImageIcon;
import com.toedter.calendar.JDateChooser;
import java.awt.Rectangle;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.text.DateFormat;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Calendar;
import java.util.GregorianCalendar;
import java.util.Vector;
import java.util.logging.Level;
import java.util.logging.Logger;
import javax.swing.JFrame;
import javax.swing.JOptionPane;

public class Main_Screen extends javax.swing.JFrame {
//    minh add
    FmConfigServer fConfigSQL = new FmConfigServer();
    XMLConfig XMLcon = new XMLConfig();
    JFrame FmConfigServer = new JFrame();
    LoginStaff LoginS = new LoginStaff();
    ProcessPublic proPublic = new ProcessPublic();
    Connect_class ConnClass = new Connect_class();
    public static String flag_Staff = "";
    private static  int dem = 0;
    
//    end minh add
    
//    a Bang
    protected boolean flagStudent = false;    
    public Connect_class cc = new Connect_class();
    protected ProcessPublic pp = new ProcessPublic();
    protected int deletedTotal = 0;
    int count = 1;
    protected int countUpdate = 0;
    boolean messageUpdate = true;
    protected boolean flagStudentUpdate = false;
    String conditionTemp = "";
    Vector data = new Vector();
//    end a Bang
    public Main_Screen() {        
        initComponents();
        ImageIcon logo = new ImageIcon(getClass().getResource("images/Logo_Aptech.jpg"));
        this.Label_logo.setIcon(logo);
        Icon_for_AITSM Make_menu = new Icon_for_AITSM();
        Make_menu.setIcon("images/login.png", "Login", Main_Screen.TabbedPane_main, 0);
        Make_menu.setIcon("images/Course.png", "Course", Main_Screen.TabbedPane_main, 1);
        Make_menu.setIcon("images/Technology.png", "Technology", Main_Screen.TabbedPane_main, 2);
        Make_menu.setIcon("images/Class.png", "Class", Main_Screen.TabbedPane_main, 3);
        Make_menu.setIcon("images/Staff.png", "Staff", Main_Screen.TabbedPane_main, 4);
        Make_menu.setIcon("images/Student.png", "Student", Main_Screen.TabbedPane_main, 5);
        Make_menu.setIcon("images/Subject.png", "Subject", Main_Screen.TabbedPane_main, 6);
        Make_menu.setIcon("images/Fine.png", "Fine", Main_Screen.TabbedPane_main, 7);
        Make_menu.setIcon("images/Attendance.png", "Attendance", Main_Screen.TabbedPane_main, 8);
        Make_menu.setIcon("images/Infor_techno.png", "Information for Technology", this.Tabbed_technology, 0);
        Make_menu.setIcon("images/Details_techno.png", "Technology details", this.Tabbed_technology, 1);
        Make_menu.setIcon("images/Class_sub.png", "Information the class", this.tabbed_class, 0);
        Make_menu.setIcon("images/TKB.png", "Scheduel of the class", this.tabbed_class, 1);
        this.date_sche = new JDateChooser();
        this.date_sche.setBounds(new Rectangle(70, 163, 136, 28));
        this.date_sche.setDateFormatString("MM/dd/yyyy");
        this.jPanel8.add(this.date_sche);
        this.date_atten = new JDateChooser();
        this.date_atten.setBounds(new Rectangle(210, 39, 128, 27));
        this.date_atten.setDateFormatString("MM/dd/yyyy");
        this.panel_atten.add(this.date_atten);
//        this.jPanelLogin.setEnabled(false);
        // login Falsec
        
        Main_Screen.TabbedPane_main.setEnabled(false);
        Main_Screen.txtLoginUser.setEnabled(false);
        Main_Screen.txtLoginPass.setEnabled(false);
        Main_Screen.btnLoginCancel.setEnabled(false);
        Main_Screen.btnLoginUser.setEnabled(false);
        Main_Screen.btn_create_new_acc.setEnabled(false);
        
        // end Login False


    }

    private void showpaneLogin(){
        
            JOptionPane.showMessageDialog(null, "aaaa");
        
    }

    @SuppressWarnings("unchecked")
    // <editor-fold defaultstate="collapsed" desc="Generated Code">//GEN-BEGIN:initComponents
    private void initComponents() {

        Panel_logo = new javax.swing.JPanel();
        Label_logo = new javax.swing.JLabel();
        Panel_logo1 = new javax.swing.JPanel();
        TabbedPane_main = new javax.swing.JTabbedPane();
        jLayeredPane1 = new javax.swing.JLayeredPane();
        jPanelLogin = new javax.swing.JPanel();
        jLabel22 = new javax.swing.JLabel();
        txtLoginUser = new javax.swing.JTextField();
        jLabel23 = new javax.swing.JLabel();
        btnLoginUser = new javax.swing.JButton();
        btn_create_new_acc = new javax.swing.JButton();
        btnLoginCancel = new javax.swing.JButton();
        txtLoginPass = new javax.swing.JPasswordField();
        btnConfigSQL = new javax.swing.JButton();
        jLayeredPane5 = new javax.swing.JLayeredPane();
        jLayeredPane2 = new javax.swing.JLayeredPane();
        Tabbed_technology = new javax.swing.JTabbedPane();
        jLayeredPane10 = new javax.swing.JLayeredPane();
        jPanel2 = new javax.swing.JPanel();
        jButton3 = new javax.swing.JButton();
        jButton4 = new javax.swing.JButton();
        jButton5 = new javax.swing.JButton();
        jScrollPane1 = new javax.swing.JScrollPane();
        jTable1 = new javax.swing.JTable();
        Label_logo2 = new javax.swing.JLabel();
        jButton21 = new javax.swing.JButton();
        jLayeredPane11 = new javax.swing.JLayeredPane();
        jPanel3 = new javax.swing.JPanel();
        jLabel4 = new javax.swing.JLabel();
        jComboBox1 = new javax.swing.JComboBox();
        jScrollPane2 = new javax.swing.JScrollPane();
        jTable2 = new javax.swing.JTable();
        Label_logo1 = new javax.swing.JLabel();
        jButton20 = new javax.swing.JButton();
        jLayeredPane3 = new javax.swing.JLayeredPane();
        tabbed_class = new javax.swing.JTabbedPane();
        jLayeredPane12 = new javax.swing.JLayeredPane();
        jPanel4 = new javax.swing.JPanel();
        Label_logo3 = new javax.swing.JLabel();
        jLabel5 = new javax.swing.JLabel();
        jComboBox2 = new javax.swing.JComboBox();
        jButton6 = new javax.swing.JButton();
        jButton7 = new javax.swing.JButton();
        jButton8 = new javax.swing.JButton();
        jButton9 = new javax.swing.JButton();
        jScrollPane3 = new javax.swing.JScrollPane();
        jTable3 = new javax.swing.JTable();
        jScrollPane4 = new javax.swing.JScrollPane();
        jTable4 = new javax.swing.JTable();
        jButton23 = new javax.swing.JButton();
        jLayeredPane13 = new javax.swing.JLayeredPane();
        jPanel7 = new javax.swing.JPanel();
        Label_logo6 = new javax.swing.JLabel();
        jButton22 = new javax.swing.JButton();
        jPanel9 = new javax.swing.JPanel();
        jButton16 = new javax.swing.JButton();
        jButton17 = new javax.swing.JButton();
        jButton18 = new javax.swing.JButton();
        jButton19 = new javax.swing.JButton();
        jScrollPane7 = new javax.swing.JScrollPane();
        jTable7 = new javax.swing.JTable();
        jPanel8 = new javax.swing.JPanel();
        jLabel11 = new javax.swing.JLabel();
        jComboBox5 = new javax.swing.JComboBox();
        jComboBox6 = new javax.swing.JComboBox();
        jComboBox7 = new javax.swing.JComboBox();
        jComboBox8 = new javax.swing.JComboBox();
        jComboBox9 = new javax.swing.JComboBox();
        jLabel12 = new javax.swing.JLabel();
        jLabel13 = new javax.swing.JLabel();
        jLabel14 = new javax.swing.JLabel();
        jLabel15 = new javax.swing.JLabel();
        jLabel16 = new javax.swing.JLabel();
        jTextField6 = new javax.swing.JTextField();
        jLabel17 = new javax.swing.JLabel();
        jTextField7 = new javax.swing.JTextField();
        jLabel18 = new javax.swing.JLabel();
        jButton14 = new javax.swing.JButton();
        jButton15 = new javax.swing.JButton();
        jLayeredPane4 = new javax.swing.JLayeredPane();
        jPanel5 = new javax.swing.JPanel();
        jButton10 = new javax.swing.JButton();
        Label_logo4 = new javax.swing.JLabel();
        btnUpdateStaff = new javax.swing.JButton();
        btnDeleteStaff = new javax.swing.JButton();
        jScrollPane5 = new javax.swing.JScrollPane();
        tb_staff = new javax.swing.JTable();
        jButton24 = new javax.swing.JButton();
        jLayeredPane6 = new javax.swing.JLayeredPane();
        ps = new javax.swing.JPanel();
        Label_logo9 = new javax.swing.JLabel();
        btnInsertStu = new javax.swing.JButton();
        btnUdateStu = new javax.swing.JButton();
        btnDeleteStu = new javax.swing.JButton();
        jButton36 = new javax.swing.JButton();
        jPanel6 = new javax.swing.JPanel();
        jLabel19 = new javax.swing.JLabel();
        jcStuTech = new javax.swing.JComboBox();
        jLabel20 = new javax.swing.JLabel();
        jcStuCourse = new javax.swing.JComboBox();
        jLabel21 = new javax.swing.JLabel();
        jcStuClass = new javax.swing.JComboBox();
        jLabel24 = new javax.swing.JLabel();
        tfStuID = new javax.swing.JTextField();
        jScrollPane8 = new javax.swing.JScrollPane();
        JTable_stu = new javax.swing.JTable();
        lbTotalStu = new javax.swing.JLabel();
        jLayeredPane7 = new javax.swing.JLayeredPane();
        jPanel11 = new javax.swing.JPanel();
        Label_logo8 = new javax.swing.JLabel();
        jButton29 = new javax.swing.JButton();
        jButton30 = new javax.swing.JButton();
        jButton31 = new javax.swing.JButton();
        jScrollPane9 = new javax.swing.JScrollPane();
        jTable9 = new javax.swing.JTable();
        jButton32 = new javax.swing.JButton();
        jLayeredPane8 = new javax.swing.JLayeredPane();
        jPanel10 = new javax.swing.JPanel();
        Label_logo10 = new javax.swing.JLabel();
        messageFine = new javax.swing.JLabel();
        jButton37 = new javax.swing.JButton();
        btnDetailFine = new javax.swing.JButton();
        panelInforFine = new javax.swing.JPanel();
        jLabel25 = new javax.swing.JLabel();
        cbTechFine = new javax.swing.JComboBox();
        jLabel26 = new javax.swing.JLabel();
        cbCourseFine = new javax.swing.JComboBox();
        jLabel27 = new javax.swing.JLabel();
        cbClassFine = new javax.swing.JComboBox();
        jLabel29 = new javax.swing.JLabel();
        cbSemesterFine = new javax.swing.JComboBox();
        jLabel28 = new javax.swing.JLabel();
        tfStudentIDFine = new javax.swing.JTextField();
        jScrollPane10 = new javax.swing.JScrollPane();
        tableFine = new javax.swing.JTable();
        jLayeredPane9 = new javax.swing.JLayeredPane();
        panel_atten = new javax.swing.JPanel();
        Label_logo5 = new javax.swing.JLabel();
        jLabel6 = new javax.swing.JLabel();
        jComboBox3 = new javax.swing.JComboBox();
        jButton13 = new javax.swing.JButton();
        jLabel7 = new javax.swing.JLabel();
        jLabel8 = new javax.swing.JLabel();
        jLabel9 = new javax.swing.JLabel();
        jLabel10 = new javax.swing.JLabel();
        jComboBox4 = new javax.swing.JComboBox();
        jTextField3 = new javax.swing.JTextField();
        jTextField4 = new javax.swing.JTextField();
        jScrollPane6 = new javax.swing.JScrollPane();
        jTable6 = new javax.swing.JTable();
        jButton25 = new javax.swing.JButton();

        setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
        setMinimumSize(null);
        setResizable(false);

        Panel_logo.setBorder(javax.swing.BorderFactory.createEtchedBorder());
        Panel_logo.setLayout(new java.awt.GridBagLayout());

        Label_logo.setFont(new java.awt.Font("Tahoma", 1, 24)); // NOI18N
        Label_logo.setForeground(new java.awt.Color(51, 0, 102));
        Label_logo.setText("Andrews Institute of technical sciences and Managerment");
        Panel_logo.add(Label_logo, new java.awt.GridBagConstraints());

        Panel_logo1.setBorder(javax.swing.BorderFactory.createEtchedBorder());
        Panel_logo1.setCursor(new java.awt.Cursor(java.awt.Cursor.DEFAULT_CURSOR));

        jLayeredPane1.setCursor(new java.awt.Cursor(java.awt.Cursor.DEFAULT_CURSOR));

        jPanelLogin.setBorder(javax.swing.BorderFactory.createTitledBorder("Login - Create account"));

        jLabel22.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N
        jLabel22.setText("User name:");

        jLabel23.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N
        jLabel23.setText("Password:");

        btnLoginUser.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N
        btnLoginUser.setText("Login");
        btnLoginUser.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                btnLoginUserActionPerformed(evt);
            }
        });

        btn_create_new_acc.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N
        btn_create_new_acc.setText("Create account");
        btn_create_new_acc.addMouseListener(new java.awt.event.MouseAdapter() {
            public void mouseClicked(java.awt.event.MouseEvent evt) {
                btn_create_new_accMouseClicked(evt);
            }
        });
        btn_create_new_acc.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                btn_create_new_accActionPerformed(evt);
            }
        });

        btnLoginCancel.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N
        btnLoginCancel.setText("Exit");
        btnLoginCancel.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                btnLoginCancelActionPerformed(evt);
            }
        });

        txtLoginPass.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N

        btnConfigSQL.setText("Config Server ");
        btnConfigSQL.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                btnConfigSQLActionPerformed(evt);
            }
        });

        javax.swing.GroupLayout jPanelLoginLayout = new javax.swing.GroupLayout(jPanelLogin);
        jPanelLogin.setLayout(jPanelLoginLayout);
        jPanelLoginLayout.setHorizontalGroup(
            jPanelLoginLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(jPanelLoginLayout.createSequentialGroup()
                .addContainerGap(131, Short.MAX_VALUE)
                .addGroup(jPanelLoginLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)
                    .addComponent(jLabel22)
                    .addComponent(jLabel23))
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addGroup(jPanelLoginLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addGroup(jPanelLoginLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)
                        .addComponent(txtLoginUser)
                        .addComponent(txtLoginPass, javax.swing.GroupLayout.PREFERRED_SIZE, 186, javax.swing.GroupLayout.PREFERRED_SIZE))
                    .addGroup(jPanelLoginLayout.createSequentialGroup()
                        .addGap(10, 10, 10)
                        .addGroup(jPanelLoginLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                            .addGroup(jPanelLoginLayout.createSequentialGroup()
                                .addGap(10, 10, 10)
                                .addGroup(jPanelLoginLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                                    .addComponent(btn_create_new_acc)
                                    .addComponent(btnConfigSQL)))
                            .addGroup(jPanelLoginLayout.createSequentialGroup()
                                .addComponent(btnLoginUser)
                                .addGap(18, 18, 18)
                                .addComponent(btnLoginCancel)))))
                .addGap(125, 125, 125))
        );
        jPanelLoginLayout.setVerticalGroup(
            jPanelLoginLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jPanelLoginLayout.createSequentialGroup()
                .addContainerGap(98, Short.MAX_VALUE)
                .addGroup(jPanelLoginLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(jLabel22)
                    .addComponent(txtLoginUser, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addGroup(jPanelLoginLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(jLabel23)
                    .addComponent(txtLoginPass, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
                .addGroup(jPanelLoginLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(btnLoginUser)
                    .addComponent(btnLoginCancel))
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addComponent(btn_create_new_acc)
                .addGap(18, 18, 18)
                .addComponent(btnConfigSQL)
                .addGap(28, 28, 28))
        );

        jPanelLogin.setBounds(340, 100, 520, 300);
        jLayeredPane1.add(jPanelLogin, javax.swing.JLayeredPane.DEFAULT_LAYER);

        TabbedPane_main.addTab("tab1", jLayeredPane1);
        TabbedPane_main.addTab("tab2", jLayeredPane5);

        jButton3.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N
        jButton3.setText("Delete Technology");

        jButton4.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N
        jButton4.setText("Insert Technology");

        jButton5.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N
        jButton5.setText("Update Technology");

        jTable1.setModel(new javax.swing.table.DefaultTableModel(
            new Object [][] {
                {null, null, null},
                {null, null, null},
                {null, null, null},
                {null, null, null}
            },
            new String [] {
                "Select record", "Technology ID", "Technology name"
            }
        ) {
            Class[] types = new Class [] {
                java.lang.Boolean.class, java.lang.Object.class, java.lang.Object.class
            };

            public Class getColumnClass(int columnIndex) {
                return types [columnIndex];
            }
        });
        jScrollPane1.setViewportView(jTable1);

        Label_logo2.setFont(new java.awt.Font("Tahoma", 1, 18)); // NOI18N
        Label_logo2.setForeground(new java.awt.Color(51, 0, 102));
        Label_logo2.setText("Information of Technology");

        jButton21.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N
        jButton21.setText("Logout");

        javax.swing.GroupLayout jPanel2Layout = new javax.swing.GroupLayout(jPanel2);
        jPanel2.setLayout(jPanel2Layout);
        jPanel2Layout.setHorizontalGroup(
            jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(jPanel2Layout.createSequentialGroup()
                .addGap(397, 397, 397)
                .addComponent(jButton4)
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addComponent(jButton3)
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addComponent(jButton5)
                .addContainerGap(440, Short.MAX_VALUE))
            .addGroup(jPanel2Layout.createSequentialGroup()
                .addGap(483, 483, 483)
                .addComponent(Label_logo2)
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                .addComponent(jButton21)
                .addGap(24, 24, 24))
            .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jPanel2Layout.createSequentialGroup()
                .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                .addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 1039, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addGap(107, 107, 107))
        );
        jPanel2Layout.setVerticalGroup(
            jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jPanel2Layout.createSequentialGroup()
                .addContainerGap()
                .addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(Label_logo2)
                    .addComponent(jButton21))
                .addGap(18, 18, 18)
                .addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(jButton4)
                    .addComponent(jButton3)
                    .addComponent(jButton5))
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
                .addComponent(jScrollPane1, javax.swing.GroupLayout.DEFAULT_SIZE, 291, Short.MAX_VALUE)
                .addContainerGap())
        );

        jPanel2.setBounds(0, 0, 1260, 390);
        jLayeredPane10.add(jPanel2, javax.swing.JLayeredPane.DEFAULT_LAYER);

        Tabbed_technology.addTab("tab1", jLayeredPane10);

        jLabel4.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N
        jLabel4.setText("Technology name:");

        jComboBox1.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "Item 1", "Item 2", "Item 3", "Item 4" }));

        jTable2.setModel(new javax.swing.table.DefaultTableModel(
            new Object [][] {
                {null, null, null, null},
                {null, null, null, null},
                {null, null, null, null},
                {null, null, null, null}
            },
            new String [] {
                "Technology name", "Course name", "Teacher", "Subject"
            }
        ));
        jScrollPane2.setViewportView(jTable2);

        Label_logo1.setFont(new java.awt.Font("Tahoma", 1, 18)); // NOI18N
        Label_logo1.setForeground(new java.awt.Color(51, 0, 102));
        Label_logo1.setText("Details information of Technology");

        jButton20.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N
        jButton20.setText("Logout");

        javax.swing.GroupLayout jPanel3Layout = new javax.swing.GroupLayout(jPanel3);
        jPanel3.setLayout(jPanel3Layout);
        jPanel3Layout.setHorizontalGroup(
            jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jPanel3Layout.createSequentialGroup()
                .addGap(0, 0, Short.MAX_VALUE)
                .addComponent(Label_logo1, javax.swing.GroupLayout.PREFERRED_SIZE, 305, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addGap(393, 393, 393)
                .addComponent(jButton20)
                .addGap(22, 22, 22))
            .addGroup(jPanel3Layout.createSequentialGroup()
                .addGroup(jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addGroup(jPanel3Layout.createSequentialGroup()
                        .addGap(494, 494, 494)
                        .addComponent(jLabel4)
                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                        .addComponent(jComboBox1, javax.swing.GroupLayout.PREFERRED_SIZE, 142, javax.swing.GroupLayout.PREFERRED_SIZE))
                    .addGroup(jPanel3Layout.createSequentialGroup()
                        .addGap(231, 231, 231)
                        .addComponent(jScrollPane2, javax.swing.GroupLayout.PREFERRED_SIZE, 785, javax.swing.GroupLayout.PREFERRED_SIZE)))
                .addContainerGap(244, Short.MAX_VALUE))
        );
        jPanel3Layout.setVerticalGroup(
            jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(jPanel3Layout.createSequentialGroup()
                .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                .addGroup(jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(jButton20)
                    .addComponent(Label_logo1))
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addGroup(jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(jLabel4)
                    .addComponent(jComboBox1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
                .addComponent(jScrollPane2, javax.swing.GroupLayout.PREFERRED_SIZE, 299, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addGap(56, 56, 56))
        );

        jPanel3.setBounds(0, 0, 1260, 420);
        jLayeredPane11.add(jPanel3, javax.swing.JLayeredPane.DEFAULT_LAYER);

        Tabbed_technology.addTab("tab2", jLayeredPane11);

        Tabbed_technology.setBounds(0, 0, 1270, 470);
        jLayeredPane2.add(Tabbed_technology, javax.swing.JLayeredPane.DEFAULT_LAYER);

        TabbedPane_main.addTab("tab3", jLayeredPane2);

        Label_logo3.setFont(new java.awt.Font("Tahoma", 1, 18)); // NOI18N
        Label_logo3.setForeground(new java.awt.Color(51, 0, 102));
        Label_logo3.setText("Information about the class");
        Label_logo3.setVerticalAlignment(javax.swing.SwingConstants.TOP);

        jLabel5.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N
        jLabel5.setText("Course name:");
        jLabel5.setVerticalAlignment(javax.swing.SwingConstants.TOP);

        jComboBox2.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "Item 1", "Item 2", "Item 3", "Item 4" }));

        jButton6.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N
        jButton6.setText("Insert");

        jButton7.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N
        jButton7.setText("Search");

        jButton8.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N
        jButton8.setText("Update");

        jButton9.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N
        jButton9.setText("Delete");

        jTable3.setModel(new javax.swing.table.DefaultTableModel(
            new Object [][] {
                {null, null, null, null, null},
                {null, null, null, null, null},
                {null, null, null, null, null},
                {null, null, null, null, null}
            },
            new String [] {
                "Select class", "Class ID", "Start date", "End date", "Course ID"
            }
        ) {
            Class[] types = new Class [] {
                java.lang.Boolean.class, java.lang.Object.class, java.lang.Object.class, java.lang.Object.class, java.lang.Object.class
            };

            public Class getColumnClass(int columnIndex) {
                return types [columnIndex];
            }
        });
        jScrollPane3.setViewportView(jTable3);

        jTable4.setModel(new javax.swing.table.DefaultTableModel(
            new Object [][] {
                {null, null, null, null},
                {null, null, null, null},
                {null, null, null, null},
                {null, null, null, null}
            },
            new String [] {
                "Title 1", "Title 2", "Title 3", "Title 4"
            }
        ));
        jTable4.setColumnSelectionAllowed(true);
        jScrollPane4.setViewportView(jTable4);
        jTable4.getColumnModel().getSelectionModel().setSelectionMode(javax.swing.ListSelectionModel.SINGLE_SELECTION);
        jTable4.getColumnModel().getColumn(0).setHeaderValue("Title 1");
        jTable4.getColumnModel().getColumn(1).setHeaderValue("Title 2");
        jTable4.getColumnModel().getColumn(2).setHeaderValue("Title 3");
        jTable4.getColumnModel().getColumn(3).setHeaderValue("Title 4");

        jButton23.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N
        jButton23.setText("Logout");

        javax.swing.GroupLayout jPanel4Layout = new javax.swing.GroupLayout(jPanel4);
        jPanel4.setLayout(jPanel4Layout);
        jPanel4Layout.setHorizontalGroup(
            jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(jPanel4Layout.createSequentialGroup()
                .addGap(494, 494, 494)
                .addComponent(Label_logo3)
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                .addComponent(jButton23)
                .addGap(20, 20, 20))
            .addGroup(jPanel4Layout.createSequentialGroup()
                .addGroup(jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addGroup(jPanel4Layout.createSequentialGroup()
                        .addGap(353, 353, 353)
                        .addComponent(jLabel5)
                        .addGap(4, 4, 4)
                        .addComponent(jComboBox2, javax.swing.GroupLayout.PREFERRED_SIZE, 164, javax.swing.GroupLayout.PREFERRED_SIZE)
                        .addGap(6, 6, 6)
                        .addComponent(jButton6)
                        .addGap(6, 6, 6)
                        .addComponent(jButton7)
                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                        .addComponent(jButton8)
                        .addGap(6, 6, 6)
                        .addComponent(jButton9))
                    .addGroup(jPanel4Layout.createSequentialGroup()
                        .addComponent(jScrollPane3, javax.swing.GroupLayout.PREFERRED_SIZE, 636, javax.swing.GroupLayout.PREFERRED_SIZE)
                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                        .addComponent(jScrollPane4, javax.swing.GroupLayout.PREFERRED_SIZE, 618, javax.swing.GroupLayout.PREFERRED_SIZE)))
                .addGap(0, 0, Short.MAX_VALUE))
        );
        jPanel4Layout.setVerticalGroup(
            jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(jPanel4Layout.createSequentialGroup()
                .addGap(11, 11, 11)
                .addGroup(jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(Label_logo3)
                    .addComponent(jButton23))
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
                .addGroup(jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addComponent(jButton8)
                    .addComponent(jButton9)
                    .addGroup(jPanel4Layout.createSequentialGroup()
                        .addGap(4, 4, 4)
                        .addComponent(jLabel5))
                    .addGroup(jPanel4Layout.createSequentialGroup()
                        .addGap(2, 2, 2)
                        .addComponent(jComboBox2, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
                    .addComponent(jButton6)
                    .addComponent(jButton7))
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
                .addGroup(jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)
                    .addComponent(jScrollPane3, javax.swing.GroupLayout.DEFAULT_SIZE, 278, Short.MAX_VALUE)
                    .addComponent(jScrollPane4, javax.swing.GroupLayout.PREFERRED_SIZE, 0, Short.MAX_VALUE))
                .addContainerGap(71, Short.MAX_VALUE))
        );

        jPanel4.setBounds(0, 0, 1260, 430);
        jLayeredPane12.add(jPanel4, javax.swing.JLayeredPane.DEFAULT_LAYER);

        tabbed_class.addTab("tab1", jLayeredPane12);

        jPanel7.setBorder(javax.swing.BorderFactory.createEtchedBorder());

        Label_logo6.setFont(new java.awt.Font("Tahoma", 1, 18)); // NOI18N
        Label_logo6.setForeground(new java.awt.Color(51, 0, 102));
        Label_logo6.setText("Information schedule");

        jButton22.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N
        jButton22.setText("Logout");

        javax.swing.GroupLayout jPanel7Layout = new javax.swing.GroupLayout(jPanel7);
        jPanel7.setLayout(jPanel7Layout);
        jPanel7Layout.setHorizontalGroup(
            jPanel7Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(jPanel7Layout.createSequentialGroup()
                .addContainerGap(549, Short.MAX_VALUE)
                .addComponent(Label_logo6)
                .addGap(429, 429, 429)
                .addComponent(jButton22)
                .addGap(21, 21, 21))
        );
        jPanel7Layout.setVerticalGroup(
            jPanel7Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(jPanel7Layout.createSequentialGroup()
                .addContainerGap()
                .addGroup(jPanel7Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(Label_logo6)
                    .addComponent(jButton22))
                .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
        );

        jPanel7.setBounds(0, 0, 1270, 50);
        jLayeredPane13.add(jPanel7, javax.swing.JLayeredPane.DEFAULT_LAYER);

        jPanel9.setBorder(javax.swing.BorderFactory.createEtchedBorder());

        jButton16.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N
        jButton16.setText("Thời khóa biểu lớp");

        jButton17.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N
        jButton17.setText("Thời khóa biểu ngày");

        jButton18.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N
        jButton18.setText("Update");

        jButton19.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N
        jButton19.setText("Delete");

        jTable7.setModel(new javax.swing.table.DefaultTableModel(
            new Object [][] {
                {null, null, null, null},
                {null, null, null, null},
                {null, null, null, null},
                {null, null, null, null},
                {null, null, null, null}
            },
            new String [] {
                "Lớp", "Môn học", "Giáo viên", "Thời gian bắt đầu"
            }
        ));
        jScrollPane7.setViewportView(jTable7);

        jPanel8.setBorder(javax.swing.BorderFactory.createEtchedBorder());

        jLabel11.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N
        jLabel11.setText("Course ID:");

        jComboBox5.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "Item 1", "Item 2", "Item 3", "Item 4" }));

        jComboBox6.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "Item 1", "Item 2", "Item 3", "Item 4" }));

        jComboBox7.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "Item 1", "Item 2", "Item 3", "Item 4" }));

        jComboBox8.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "Item 1", "Item 2", "Item 3", "Item 4" }));

        jComboBox9.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "Item 1", "Item 2", "Item 3", "Item 4" }));

        jLabel12.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N
        jLabel12.setText("Class ID:");

        jLabel13.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N
        jLabel13.setText("Semester:");

        jLabel14.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N
        jLabel14.setText("Subject:");

        jLabel15.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N
        jLabel15.setText("Teacher:");

        jLabel16.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N
        jLabel16.setText("Date:");

        jLabel17.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N
        jLabel17.setText("Giờ:");

        jLabel18.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N
        jLabel18.setText("Thời gian:");

        jButton14.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N
        jButton14.setText("OK");

        jButton15.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N
        jButton15.setText("Cancel");

        javax.swing.GroupLayout jPanel8Layout = new javax.swing.GroupLayout(jPanel8);
        jPanel8.setLayout(jPanel8Layout);
        jPanel8Layout.setHorizontalGroup(
            jPanel8Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(jPanel8Layout.createSequentialGroup()
                .addGroup(jPanel8Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addGroup(jPanel8Layout.createSequentialGroup()
                        .addContainerGap()
                        .addGroup(jPanel8Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)
                            .addGroup(jPanel8Layout.createSequentialGroup()
                                .addComponent(jLabel12)
                                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                                .addComponent(jComboBox6, javax.swing.GroupLayout.PREFERRED_SIZE, 136, javax.swing.GroupLayout.PREFERRED_SIZE))
                            .addGroup(jPanel8Layout.createSequentialGroup()
                                .addComponent(jLabel11)
                                .addGap(3, 3, 3)
                                .addComponent(jComboBox5, javax.swing.GroupLayout.PREFERRED_SIZE, 136, javax.swing.GroupLayout.PREFERRED_SIZE))
                            .addGroup(jPanel8Layout.createSequentialGroup()
                                .addComponent(jLabel14)
                                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                                .addComponent(jComboBox8, javax.swing.GroupLayout.PREFERRED_SIZE, 136, javax.swing.GroupLayout.PREFERRED_SIZE))
                            .addGroup(jPanel8Layout.createSequentialGroup()
                                .addComponent(jLabel13)
                                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                                .addComponent(jComboBox7, javax.swing.GroupLayout.PREFERRED_SIZE, 136, javax.swing.GroupLayout.PREFERRED_SIZE))
                            .addGroup(jPanel8Layout.createSequentialGroup()
                                .addGroup(jPanel8Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)
                                    .addComponent(jLabel16)
                                    .addComponent(jLabel15)
                                    .addComponent(jLabel17)
                                    .addComponent(jLabel18))
                                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                                .addGroup(jPanel8Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)
                                    .addComponent(jComboBox9, 0, 136, Short.MAX_VALUE)
                                    .addComponent(jTextField6)
                                    .addComponent(jTextField7)))))
                    .addGroup(jPanel8Layout.createSequentialGroup()
                        .addGap(56, 56, 56)
                        .addComponent(jButton14)
                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                        .addComponent(jButton15)))
                .addContainerGap(134, Short.MAX_VALUE))
        );
        jPanel8Layout.setVerticalGroup(
            jPanel8Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(jPanel8Layout.createSequentialGroup()
                .addContainerGap()
                .addGroup(jPanel8Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(jLabel11)
                    .addComponent(jComboBox5, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addGroup(jPanel8Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(jComboBox6, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addComponent(jLabel12))
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addGroup(jPanel8Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(jComboBox7, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addComponent(jLabel13))
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addGroup(jPanel8Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(jComboBox8, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addComponent(jLabel14))
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addGroup(jPanel8Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(jComboBox9, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addComponent(jLabel15))
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addComponent(jLabel16)
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addGroup(jPanel8Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(jTextField6, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addComponent(jLabel17))
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addGroup(jPanel8Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(jTextField7, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addComponent(jLabel18))
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
                .addGroup(jPanel8Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(jButton15)
                    .addComponent(jButton14))
                .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
        );

        javax.swing.GroupLayout jPanel9Layout = new javax.swing.GroupLayout(jPanel9);
        jPanel9.setLayout(jPanel9Layout);
        jPanel9Layout.setHorizontalGroup(
            jPanel9Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(jPanel9Layout.createSequentialGroup()
                .addGroup(jPanel9Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addComponent(jScrollPane7, javax.swing.GroupLayout.DEFAULT_SIZE, 910, Short.MAX_VALUE)
                    .addGroup(jPanel9Layout.createSequentialGroup()
                        .addGap(201, 201, 201)
                        .addComponent(jButton16)
                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                        .addComponent(jButton17)
                        .addGap(18, 18, 18)
                        .addComponent(jButton18)
                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
                        .addComponent(jButton19)
                        .addGap(0, 0, Short.MAX_VALUE)))
                .addGap(2, 2, 2)
                .addComponent(jPanel8, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addContainerGap())
        );
        jPanel9Layout.setVerticalGroup(
            jPanel9Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(jPanel9Layout.createSequentialGroup()
                .addContainerGap()
                .addGroup(jPanel9Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)
                    .addComponent(jPanel8, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                    .addGroup(jPanel9Layout.createSequentialGroup()
                        .addGroup(jPanel9Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                            .addComponent(jButton16)
                            .addComponent(jButton17)
                            .addComponent(jButton18)
                            .addComponent(jButton19))
                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
                        .addComponent(jScrollPane7, javax.swing.GroupLayout.PREFERRED_SIZE, 263, javax.swing.GroupLayout.PREFERRED_SIZE)))
                .addContainerGap(68, Short.MAX_VALUE))
        );

        jPanel9.setBounds(0, 50, 1270, 380);
        jLayeredPane13.add(jPanel9, javax.swing.JLayeredPane.DEFAULT_LAYER);

        tabbed_class.addTab("tab2", jLayeredPane13);

        tabbed_class.setBounds(0, 0, 1270, 450);
        jLayeredPane3.add(tabbed_class, javax.swing.JLayeredPane.DEFAULT_LAYER);

        TabbedPane_main.addTab("tab4", jLayeredPane3);

        jButton10.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N
        jButton10.setText("Insert Staff");
        jButton10.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jButton10ActionPerformed(evt);
            }
        });

        Label_logo4.setFont(new java.awt.Font("Tahoma", 1, 18)); // NOI18N
        Label_logo4.setForeground(new java.awt.Color(51, 0, 102));
        Label_logo4.setText("Information about Staff");
        Label_logo4.setVerticalAlignment(javax.swing.SwingConstants.TOP);

        btnUpdateStaff.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N
        btnUpdateStaff.setText("Update Staff");
        btnUpdateStaff.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                btnUpdateStaffActionPerformed(evt);
            }
        });

        btnDeleteStaff.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N
        btnDeleteStaff.setText("Delete Staff");
        btnDeleteStaff.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                btnDeleteStaffActionPerformed(evt);
            }
        });

        tb_staff.setModel(new javax.swing.table.DefaultTableModel(
            new Object [][] {

            },
            new String [] {

            }
        ));
        tb_staff.addAncestorListener(new javax.swing.event.AncestorListener() {
            public void ancestorMoved(javax.swing.event.AncestorEvent evt) {
            }
            public void ancestorAdded(javax.swing.event.AncestorEvent evt) {
                tb_staffAncestorAdded(evt);
            }
            public void ancestorRemoved(javax.swing.event.AncestorEvent evt) {
            }
        });
        jScrollPane5.setViewportView(tb_staff);

        jButton24.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N
        jButton24.setText("Logout");

        javax.swing.GroupLayout jPanel5Layout = new javax.swing.GroupLayout(jPanel5);
        jPanel5.setLayout(jPanel5Layout);
        jPanel5Layout.setHorizontalGroup(
            jPanel5Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(jPanel5Layout.createSequentialGroup()
                .addGroup(jPanel5Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addComponent(jScrollPane5)
                    .addGroup(jPanel5Layout.createSequentialGroup()
                        .addGap(439, 439, 439)
                        .addComponent(jButton10)
                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                        .addComponent(btnUpdateStaff)
                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                        .addComponent(btnDeleteStaff)
                        .addGap(0, 0, Short.MAX_VALUE)))
                .addContainerGap())
            .addGroup(jPanel5Layout.createSequentialGroup()
                .addGap(495, 495, 495)
                .addComponent(Label_logo4)
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 459, Short.MAX_VALUE)
                .addComponent(jButton24)
                .addGap(30, 30, 30))
        );
        jPanel5Layout.setVerticalGroup(
            jPanel5Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(jPanel5Layout.createSequentialGroup()
                .addGap(12, 12, 12)
                .addGroup(jPanel5Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(Label_logo4)
                    .addComponent(jButton24))
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addGroup(jPanel5Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(jButton10)
                    .addComponent(btnUpdateStaff)
                    .addComponent(btnDeleteStaff))
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addComponent(jScrollPane5, javax.swing.GroupLayout.PREFERRED_SIZE, 340, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addContainerGap(38, Short.MAX_VALUE))
        );

        jPanel5.setBounds(0, 0, 1270, 450);
        jLayeredPane4.add(jPanel5, javax.swing.JLayeredPane.DEFAULT_LAYER);

        TabbedPane_main.addTab("tab5", jLayeredPane4);

        Label_logo9.setFont(new java.awt.Font("Tahoma", 1, 18)); // NOI18N
        Label_logo9.setForeground(new java.awt.Color(51, 0, 102));
        Label_logo9.setText("Manager the student");
        Label_logo9.setVerticalAlignment(javax.swing.SwingConstants.TOP);

        btnInsertStu.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N
        btnInsertStu.setText("Insert Student");
        btnInsertStu.setCursor(new java.awt.Cursor(java.awt.Cursor.DEFAULT_CURSOR));
        btnInsertStu.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                btnInsertStu(evt);
            }
        });

        btnUdateStu.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N
        btnUdateStu.setText("Update Student");
        btnUdateStu.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                btnUdateStuActionPerformed(evt);
            }
        });

        btnDeleteStu.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N
        btnDeleteStu.setText("Delete Student");
        btnDeleteStu.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                btnDeleteStuActionPerformed(evt);
            }
        });

        jButton36.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N
        jButton36.setText("Logout");

        javax.swing.GroupLayout psLayout = new javax.swing.GroupLayout(ps);
        ps.setLayout(psLayout);
        psLayout.setHorizontalGroup(
            psLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(psLayout.createSequentialGroup()
                .addGroup(psLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addGroup(psLayout.createSequentialGroup()
                        .addGap(508, 508, 508)
                        .addComponent(Label_logo9)
                        .addGap(0, 0, Short.MAX_VALUE))
                    .addGroup(psLayout.createSequentialGroup()
                        .addGap(432, 432, 432)
                        .addComponent(btnInsertStu)
                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                        .addComponent(btnUdateStu)
                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                        .addComponent(btnDeleteStu)
                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 394, Short.MAX_VALUE)
                        .addComponent(jButton36)))
                .addContainerGap())
        );
        psLayout.setVerticalGroup(
            psLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(psLayout.createSequentialGroup()
                .addContainerGap()
                .addComponent(Label_logo9)
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
                .addGroup(psLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(btnInsertStu)
                    .addComponent(btnUdateStu)
                    .addComponent(btnDeleteStu)
                    .addComponent(jButton36))
                .addContainerGap(13, Short.MAX_VALUE))
        );

        ps.setBounds(0, 0, 1270, 80);
        jLayeredPane6.add(ps, javax.swing.JLayeredPane.DEFAULT_LAYER);

        jLabel19.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N
        jLabel19.setText("Technology name:");
        jLabel19.setVerticalAlignment(javax.swing.SwingConstants.TOP);

        jcStuTech.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jcStuTechActionPerformed(evt);
            }
        });

        jLabel20.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N
        jLabel20.setText("Course name:");
        jLabel20.setVerticalAlignment(javax.swing.SwingConstants.TOP);

        jcStuCourse.addItemListener(new java.awt.event.ItemListener() {
            public void itemStateChanged(java.awt.event.ItemEvent evt) {
                jcStuCourseItemStateChanged(evt);
            }
        });

        jLabel21.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N
        jLabel21.setText("Class ID:");
        jLabel21.setVerticalAlignment(javax.swing.SwingConstants.TOP);

        jcStuClass.addItemListener(new java.awt.event.ItemListener() {
            public void itemStateChanged(java.awt.event.ItemEvent evt) {
                jcStuClassItemStateChanged(evt);
            }
        });
        jcStuClass.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jcStuClassActionPerformed(evt);
            }
        });

        jLabel24.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N
        jLabel24.setText("Search student ID:");
        jLabel24.setVerticalAlignment(javax.swing.SwingConstants.TOP);

        tfStuID.addKeyListener(new java.awt.event.KeyAdapter() {
            public void keyPressed(java.awt.event.KeyEvent evt) {
                tfStuIDKeyPressed(evt);
            }
        });

        JTable_stu.setModel(new javax.swing.table.DefaultTableModel(
            new Object [][] {
                {},
                {},
                {},
                {}
            },
            new String [] {

            }
        ));
        jScrollPane8.setViewportView(JTable_stu);

        lbTotalStu.setFont(new java.awt.Font("Tahoma", 1, 12)); // NOI18N
        lbTotalStu.setVerticalAlignment(javax.swing.SwingConstants.TOP);

        javax.swing.GroupLayout jPanel6Layout = new javax.swing.GroupLayout(jPanel6);
        jPanel6.setLayout(jPanel6Layout);
        jPanel6Layout.setHorizontalGroup(
            jPanel6Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jPanel6Layout.createSequentialGroup()
                .addContainerGap()
                .addGroup(jPanel6Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)
                    .addGroup(jPanel6Layout.createSequentialGroup()
                        .addComponent(lbTotalStu)
                        .addGap(0, 0, Short.MAX_VALUE))
                    .addGroup(jPanel6Layout.createSequentialGroup()
                        .addGap(0, 108, Short.MAX_VALUE)
                        .addComponent(jLabel19)
                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                        .addComponent(jcStuTech, javax.swing.GroupLayout.PREFERRED_SIZE, 164, javax.swing.GroupLayout.PREFERRED_SIZE)
                        .addGap(18, 18, 18)
                        .addComponent(jLabel20)
                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                        .addComponent(jcStuCourse, javax.swing.GroupLayout.PREFERRED_SIZE, 164, javax.swing.GroupLayout.PREFERRED_SIZE)
                        .addGap(18, 18, 18)
                        .addComponent(jLabel21)))
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addComponent(jcStuClass, javax.swing.GroupLayout.PREFERRED_SIZE, 164, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addGap(18, 18, 18)
                .addComponent(jLabel24)
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addComponent(tfStuID, javax.swing.GroupLayout.PREFERRED_SIZE, 145, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addGap(119, 119, 119))
            .addGroup(jPanel6Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                .addGroup(jPanel6Layout.createSequentialGroup()
                    .addGap(11, 11, 11)
                    .addComponent(jScrollPane8, javax.swing.GroupLayout.DEFAULT_SIZE, 1249, Short.MAX_VALUE)
                    .addContainerGap()))
        );
        jPanel6Layout.setVerticalGroup(
            jPanel6Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(jPanel6Layout.createSequentialGroup()
                .addGroup(jPanel6Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addGroup(jPanel6Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                        .addComponent(jLabel21)
                        .addComponent(jcStuClass, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                        .addComponent(jLabel24)
                        .addComponent(tfStuID, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
                    .addGroup(jPanel6Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                        .addComponent(jLabel20)
                        .addComponent(jcStuCourse, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
                    .addGroup(jPanel6Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                        .addComponent(jLabel19)
                        .addComponent(jcStuTech, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)))
                .addGap(18, 18, 18)
                .addComponent(lbTotalStu)
                .addGap(0, 442, Short.MAX_VALUE))
            .addGroup(jPanel6Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                .addGroup(jPanel6Layout.createSequentialGroup()
                    .addGap(63, 63, 63)
                    .addComponent(jScrollPane8, javax.swing.GroupLayout.PREFERRED_SIZE, 369, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addContainerGap(48, Short.MAX_VALUE)))
        );

        jPanel6.setBounds(0, 80, 1270, 480);
        jLayeredPane6.add(jPanel6, javax.swing.JLayeredPane.DEFAULT_LAYER);

        TabbedPane_main.addTab("tab6", jLayeredPane6);

        Label_logo8.setFont(new java.awt.Font("Tahoma", 1, 18)); // NOI18N
        Label_logo8.setForeground(new java.awt.Color(51, 0, 102));
        Label_logo8.setText("Information about the subject");
        Label_logo8.setVerticalAlignment(javax.swing.SwingConstants.TOP);

        jButton29.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N
        jButton29.setText("Insert subject");

        jButton30.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N
        jButton30.setText("Update subject");

        jButton31.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N
        jButton31.setText("Delete subject");

        jTable9.setModel(new javax.swing.table.DefaultTableModel(
            new Object [][] {
                {null, null, null, null},
                {null, null, null, null},
                {null, null, null, null},
                {null, null, null, null}
            },
            new String [] {
                "Selection subject", "Subject ID", "Subject name", "Technology ID"
            }
        ) {
            Class[] types = new Class [] {
                java.lang.Boolean.class, java.lang.Object.class, java.lang.Object.class, java.lang.Object.class
            };

            public Class getColumnClass(int columnIndex) {
                return types [columnIndex];
            }
        });
        jScrollPane9.setViewportView(jTable9);

        jButton32.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N
        jButton32.setText("Logout");

        javax.swing.GroupLayout jPanel11Layout = new javax.swing.GroupLayout(jPanel11);
        jPanel11.setLayout(jPanel11Layout);
        jPanel11Layout.setHorizontalGroup(
            jPanel11Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(jPanel11Layout.createSequentialGroup()
                .addGap(473, 473, 473)
                .addComponent(Label_logo8)
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                .addComponent(jButton32)
                .addGap(31, 31, 31))
            .addGroup(jPanel11Layout.createSequentialGroup()
                .addGroup(jPanel11Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addGroup(jPanel11Layout.createSequentialGroup()
                        .addGap(441, 441, 441)
                        .addComponent(jButton29)
                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                        .addComponent(jButton30)
                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                        .addComponent(jButton31))
                    .addGroup(jPanel11Layout.createSequentialGroup()
                        .addGap(218, 218, 218)
                        .addComponent(jScrollPane9, javax.swing.GroupLayout.PREFERRED_SIZE, 787, javax.swing.GroupLayout.PREFERRED_SIZE)))
                .addContainerGap(265, Short.MAX_VALUE))
        );
        jPanel11Layout.setVerticalGroup(
            jPanel11Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(jPanel11Layout.createSequentialGroup()
                .addGap(12, 12, 12)
                .addGroup(jPanel11Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(Label_logo8)
                    .addComponent(jButton32))
                .addGap(18, 18, 18)
                .addGroup(jPanel11Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(jButton29)
                    .addComponent(jButton30)
                    .addComponent(jButton31))
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addComponent(jScrollPane9, javax.swing.GroupLayout.PREFERRED_SIZE, 308, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addContainerGap(58, Short.MAX_VALUE))
        );

        jPanel11.setBounds(0, 0, 1270, 450);
        jLayeredPane7.add(jPanel11, javax.swing.JLayeredPane.DEFAULT_LAYER);

        TabbedPane_main.addTab("tab7", jLayeredPane7);

        Label_logo10.setFont(new java.awt.Font("Tahoma", 1, 18)); // NOI18N
        Label_logo10.setForeground(new java.awt.Color(51, 0, 102));
        Label_logo10.setText("Information fines of students");
        Label_logo10.setVerticalAlignment(javax.swing.SwingConstants.TOP);

        messageFine.setFont(new java.awt.Font("Tahoma", 1, 14)); // NOI18N
        messageFine.setVerticalAlignment(javax.swing.SwingConstants.TOP);

        jButton37.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N
        jButton37.setText("Logout");

        btnDetailFine.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N
        btnDetailFine.setText("Detail fine of the student");
        btnDetailFine.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                btnDetailFineActionPerformed(evt);
            }
        });

        javax.swing.GroupLayout jPanel10Layout = new javax.swing.GroupLayout(jPanel10);
        jPanel10.setLayout(jPanel10Layout);
        jPanel10Layout.setHorizontalGroup(
            jPanel10Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(jPanel10Layout.createSequentialGroup()
                .addGroup(jPanel10Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)
                    .addGroup(jPanel10Layout.createSequentialGroup()
                        .addGap(474, 474, 474)
                        .addGroup(jPanel10Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)
                            .addGroup(jPanel10Layout.createSequentialGroup()
                                .addComponent(Label_logo10)
                                .addGap(424, 424, 424))
                            .addComponent(messageFine, javax.swing.GroupLayout.PREFERRED_SIZE, 352, javax.swing.GroupLayout.PREFERRED_SIZE))
                        .addGap(0, 97, Short.MAX_VALUE))
                    .addGroup(jPanel10Layout.createSequentialGroup()
                        .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                        .addComponent(btnDetailFine)
                        .addGap(498, 498, 498)
                        .addComponent(jButton37)))
                .addContainerGap())
        );
        jPanel10Layout.setVerticalGroup(
            jPanel10Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(jPanel10Layout.createSequentialGroup()
                .addContainerGap()
                .addComponent(Label_logo10)
                .addGap(12, 12, 12)
                .addGroup(jPanel10Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(jButton37)
                    .addComponent(btnDetailFine))
                .addGap(9, 9, 9)
                .addComponent(messageFine, javax.swing.GroupLayout.PREFERRED_SIZE, 21, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
        );

        jPanel10.setBounds(0, 0, 1270, 70);
        jLayeredPane8.add(jPanel10, javax.swing.JLayeredPane.DEFAULT_LAYER);

        jLabel25.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N
        jLabel25.setText("Technology name:");
        jLabel25.setVerticalAlignment(javax.swing.SwingConstants.TOP);

        cbTechFine.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                cbTechFineActionPerformed(evt);
            }
        });

        jLabel26.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N
        jLabel26.setText("Course name:");
        jLabel26.setVerticalAlignment(javax.swing.SwingConstants.TOP);

        cbCourseFine.addItemListener(new java.awt.event.ItemListener() {
            public void itemStateChanged(java.awt.event.ItemEvent evt) {
                cbCourseFineItemStateChanged(evt);
            }
        });

        jLabel27.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N
        jLabel27.setText("Class name:");
        jLabel27.setVerticalAlignment(javax.swing.SwingConstants.TOP);

        cbClassFine.addItemListener(new java.awt.event.ItemListener() {
            public void itemStateChanged(java.awt.event.ItemEvent evt) {
                cbClassFineItemStateChanged(evt);
            }
        });

        jLabel29.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N
        jLabel29.setText("Semester:");
        jLabel29.setVerticalAlignment(javax.swing.SwingConstants.TOP);

        cbSemesterFine.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                cbSemesterFineActionPerformed(evt);
            }
        });

        jLabel28.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N
        jLabel28.setText("Search student ID:");
        jLabel28.setVerticalAlignment(javax.swing.SwingConstants.TOP);

        tfStudentIDFine.addKeyListener(new java.awt.event.KeyAdapter() {
            public void keyPressed(java.awt.event.KeyEvent evt) {
                tfStudentIDFineKeyPressed(evt);
            }
        });

        tableFine.setModel(new javax.swing.table.DefaultTableModel(
            new Object [][] {

            },
            new String [] {

            }
        ));
        jScrollPane10.setViewportView(tableFine);

        javax.swing.GroupLayout panelInforFineLayout = new javax.swing.GroupLayout(panelInforFine);
        panelInforFine.setLayout(panelInforFineLayout);
        panelInforFineLayout.setHorizontalGroup(
            panelInforFineLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, panelInforFineLayout.createSequentialGroup()
                .addContainerGap(114, Short.MAX_VALUE)
                .addComponent(jLabel25)
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addComponent(cbTechFine, javax.swing.GroupLayout.PREFERRED_SIZE, 152, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addGap(18, 18, 18)
                .addComponent(jLabel26)
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addComponent(cbCourseFine, javax.swing.GroupLayout.PREFERRED_SIZE, 132, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addGap(18, 18, 18)
                .addComponent(jLabel27)
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addComponent(cbClassFine, javax.swing.GroupLayout.PREFERRED_SIZE, 122, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addGap(18, 18, 18)
                .addComponent(jLabel29)
                .addGap(3, 3, 3)
                .addComponent(cbSemesterFine, javax.swing.GroupLayout.PREFERRED_SIZE, 52, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
                .addComponent(jLabel28)
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addComponent(tfStudentIDFine, javax.swing.GroupLayout.PREFERRED_SIZE, 145, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addGap(70, 70, 70))
            .addComponent(jScrollPane10)
        );
        panelInforFineLayout.setVerticalGroup(
            panelInforFineLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(panelInforFineLayout.createSequentialGroup()
                .addGap(25, 25, 25)
                .addGroup(panelInforFineLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addGroup(panelInforFineLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                        .addComponent(jLabel28)
                        .addComponent(tfStudentIDFine, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
                    .addGroup(panelInforFineLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                        .addComponent(jLabel25)
                        .addComponent(cbTechFine, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                        .addComponent(jLabel26)
                        .addComponent(cbCourseFine, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                        .addComponent(jLabel27)
                        .addComponent(cbClassFine, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                        .addComponent(jLabel29)
                        .addComponent(cbSemesterFine, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)))
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addComponent(jScrollPane10, javax.swing.GroupLayout.PREFERRED_SIZE, 367, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addContainerGap(72, Short.MAX_VALUE))
        );

        panelInforFine.setBounds(0, 70, 1270, 490);
        jLayeredPane8.add(panelInforFine, javax.swing.JLayeredPane.DEFAULT_LAYER);

        TabbedPane_main.addTab("tab8", jLayeredPane8);

        Label_logo5.setFont(new java.awt.Font("Tahoma", 1, 18)); // NOI18N
        Label_logo5.setForeground(new java.awt.Color(51, 0, 102));
        Label_logo5.setText("Attendance to the student");
        Label_logo5.setVerticalAlignment(javax.swing.SwingConstants.TOP);

        jLabel6.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N
        jLabel6.setText("Ngày tháng:");
        jLabel6.setVerticalAlignment(javax.swing.SwingConstants.TOP);

        jComboBox3.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "Item 1", "Item 2", "Item 3", "Item 4" }));

        jButton13.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N
        jButton13.setText("Finish");

        jLabel7.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N
        jLabel7.setText("Class:");
        jLabel7.setVerticalAlignment(javax.swing.SwingConstants.TOP);

        jLabel8.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N
        jLabel8.setText("Subject:");
        jLabel8.setVerticalAlignment(javax.swing.SwingConstants.TOP);

        jLabel9.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N
        jLabel9.setText("Semester:");
        jLabel9.setVerticalAlignment(javax.swing.SwingConstants.TOP);

        jLabel10.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N
        jLabel10.setText("Teacher ID:");
        jLabel10.setVerticalAlignment(javax.swing.SwingConstants.TOP);

        jComboBox4.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "Item 1", "Item 2", "Item 3", "Item 4" }));

        jTextField3.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N
        jTextField3.setHorizontalAlignment(javax.swing.JTextField.LEFT);

        jTextField4.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N
        jTextField4.setHorizontalAlignment(javax.swing.JTextField.LEFT);

        jTable6.setModel(new javax.swing.table.DefaultTableModel(
            new Object [][] {
                {null, null, null, null},
                {null, null, null, null},
                {null, null, null, null},
                {null, null, null, null}
            },
            new String [] {
                "Full name", "Student ID", "Subject's time", "Attendance"
            }
        ) {
            Class[] types = new Class [] {
                java.lang.Object.class, java.lang.Object.class, java.lang.Object.class, java.lang.Boolean.class
            };

            public Class getColumnClass(int columnIndex) {
                return types [columnIndex];
            }
        });
        jScrollPane6.setViewportView(jTable6);

        jButton25.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N
        jButton25.setText("Logout");

        javax.swing.GroupLayout panel_attenLayout = new javax.swing.GroupLayout(panel_atten);
        panel_atten.setLayout(panel_attenLayout);
        panel_attenLayout.setHorizontalGroup(
            panel_attenLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(panel_attenLayout.createSequentialGroup()
                .addGap(461, 461, 461)
                .addComponent(Label_logo5)
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                .addComponent(jButton25)
                .addGap(32, 32, 32))
            .addGroup(panel_attenLayout.createSequentialGroup()
                .addGroup(panel_attenLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addGroup(panel_attenLayout.createSequentialGroup()
                        .addGap(137, 137, 137)
                        .addGroup(panel_attenLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)
                            .addComponent(jButton13)
                            .addGroup(panel_attenLayout.createSequentialGroup()
                                .addComponent(jLabel6)
                                .addGap(150, 150, 150)
                                .addComponent(jLabel7)
                                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                                .addComponent(jComboBox3, javax.swing.GroupLayout.PREFERRED_SIZE, 164, javax.swing.GroupLayout.PREFERRED_SIZE)
                                .addGap(18, 18, 18)
                                .addComponent(jLabel8)))
                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                        .addComponent(jComboBox4, javax.swing.GroupLayout.PREFERRED_SIZE, 164, javax.swing.GroupLayout.PREFERRED_SIZE)
                        .addGap(18, 18, 18)
                        .addComponent(jLabel9)
                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                        .addComponent(jTextField4, javax.swing.GroupLayout.PREFERRED_SIZE, 54, javax.swing.GroupLayout.PREFERRED_SIZE)
                        .addGap(18, 18, 18)
                        .addComponent(jLabel10)
                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                        .addComponent(jTextField3, javax.swing.GroupLayout.PREFERRED_SIZE, 78, javax.swing.GroupLayout.PREFERRED_SIZE))
                    .addGroup(panel_attenLayout.createSequentialGroup()
                        .addGap(217, 217, 217)
                        .addComponent(jScrollPane6, javax.swing.GroupLayout.PREFERRED_SIZE, 792, javax.swing.GroupLayout.PREFERRED_SIZE)))
                .addContainerGap(188, Short.MAX_VALUE))
        );
        panel_attenLayout.setVerticalGroup(
            panel_attenLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(panel_attenLayout.createSequentialGroup()
                .addContainerGap()
                .addGroup(panel_attenLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(Label_logo5)
                    .addComponent(jButton25))
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addGroup(panel_attenLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(jLabel6)
                    .addComponent(jLabel7)
                    .addComponent(jComboBox3, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addComponent(jLabel8)
                    .addComponent(jComboBox4, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addComponent(jLabel9)
                    .addComponent(jTextField3, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addComponent(jLabel10)
                    .addComponent(jTextField4, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
                .addComponent(jButton13)
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addComponent(jScrollPane6, javax.swing.GroupLayout.PREFERRED_SIZE, 296, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addContainerGap(61, Short.MAX_VALUE))
        );

        panel_atten.setBounds(0, 0, 1270, 460);
        jLayeredPane9.add(panel_atten, javax.swing.JLayeredPane.DEFAULT_LAYER);

        TabbedPane_main.addTab("tab9", jLayeredPane9);

        javax.swing.GroupLayout Panel_logo1Layout = new javax.swing.GroupLayout(Panel_logo1);
        Panel_logo1.setLayout(Panel_logo1Layout);
        Panel_logo1Layout.setHorizontalGroup(
            Panel_logo1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addComponent(TabbedPane_main, javax.swing.GroupLayout.DEFAULT_SIZE, 1266, Short.MAX_VALUE)
        );
        Panel_logo1Layout.setVerticalGroup(
            Panel_logo1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addComponent(TabbedPane_main, javax.swing.GroupLayout.DEFAULT_SIZE, 508, Short.MAX_VALUE)
        );

        javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
        getContentPane().setLayout(layout);
        layout.setHorizontalGroup(
            layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addComponent(Panel_logo, javax.swing.GroupLayout.DEFAULT_SIZE, 1270, Short.MAX_VALUE)
            .addComponent(Panel_logo1, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
        );
        layout.setVerticalGroup(
            layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(layout.createSequentialGroup()
                .addComponent(Panel_logo, javax.swing.GroupLayout.PREFERRED_SIZE, 71, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addGap(17, 17, 17)
                .addComponent(Panel_logo1, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
        );

        pack();
    }// </editor-fold>//GEN-END:initComponents

    private void btn_create_new_accMouseClicked(java.awt.event.MouseEvent evt) {//GEN-FIRST:event_btn_create_new_accMouseClicked
        Create_account ca = new Create_account();
        ca.setVisible(true);
    }//GEN-LAST:event_btn_create_new_accMouseClicked

    private void btnConfigSQLActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_btnConfigSQLActionPerformed
        // TODO add your handling code here:
              
        fConfigSQL.setVisible(true);
        fConfigSQL.LoadConfigServer();     
        if (XMLcon.con != null) {
            fConfigSQL.setVisible(false);
        }

        
    }//GEN-LAST:event_btnConfigSQLActionPerformed

    private void btnLoginUserActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_btnLoginUserActionPerformed
        // TODO add your handling code here:sout    
//        System.out.println( txtLoginPass.getPassword());
        if (XMLcon.con != null) {
//            System.out.println( txtLoginPass.getPassword());
            LoginS.login(txtLoginUser.getText(), txtLoginPass.getText());
        }
        
        
    }//GEN-LAST:event_btnLoginUserActionPerformed

    private void btnLoginCancelActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_btnLoginCancelActionPerformed
        // TODO add your handling code here:
        System.exit(0);
    }//GEN-LAST:event_btnLoginCancelActionPerformed
//    Tab Staff (Minh)
    private void tb_staffAncestorAdded(javax.swing.event.AncestorEvent evt) {//GEN-FIRST:event_tb_staffAncestorAdded
        // TODO add your handling code here:
        if (LoginS.rule) {
//            staff
        }else{
//          show  admin ben class LoginStaff
            LoginS.showStaffAdmin();
        }

    }//GEN-LAST:event_tb_staffAncestorAdded

    private void btn_create_new_accActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_btn_create_new_accActionPerformed
        // TODO add your handling code here:
    }//GEN-LAST:event_btn_create_new_accActionPerformed

    private void jButton10ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton10ActionPerformed
        // TODO add your handling code here:
        flag_Staff = "add";
        if (flag_Staff == "add") {
            Create_account ca = new Create_account();
            ca.setVisible(true);
            ca.cbStaff_ID.setVisible(false);
    //        ca.lblState.setVisible(false);
            ca.cbStaff_State.setVisible(false);
            String SQL_tech = "Select technology_name From techology";
            ResultSet rs_tech = ConnClass.getRecordSet(SQL_tech);
            proPublic.JCompoBoxRecordSet(ca.cbTechnology, rs_tech, 1);
            
        }

            
    }//GEN-LAST:event_jButton10ActionPerformed
    
    
    private void btnDeleteStaffActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_btnDeleteStaffActionPerformed
        // TODO add your handling code here:
        flag_Staff = "delete";
        
        String sStaffID = "";
        String sTechnologyName = "";

        Label_logo1.setText("Delete Account Staff");        
        for ( int i = 0 ; i < tb_staff.getRowCount(); i ++){
            if (tb_staff.getValueAt(i,12) == null) {
                
            }else if(tb_staff.getValueAt(i,12) == true){
                
                sStaffID = tb_staff.getValueAt(i, 0).toString();
                sTechnologyName = tb_staff.getValueAt(i, 11).toString();
                ResultSet rs_S_SJ = ConnClass.getRecordSet("SELECT [subject_id] FROM [AITSM].[dbo].[staff_subject] where staff_id = '" + sStaffID + "' " );
                String sSJ_id = "";
                
                try {
                    if (rs_S_SJ.next()) {
                        sSJ_id = rs_S_SJ.getString("subject_id").toString();
                    }
                } catch (SQLException ex) {
                    Logger.getLogger(Main_Screen.class.getName()).log(Level.SEVERE, null, ex);
                }
                if (sTechnologyName.equals("NULL") && "".equals(sSJ_id)) {
                    JOptionPane.showMessageDialog(null, sStaffID + ": Tech = NULL");
                    
                        try {
                            JOptionPane.showMessageDialog(null, sStaffID + ": Subject_Staff = NULL");
                            String sqlDeleteRule = "DELETE FROM [Rule] WHERE staff_id ='"+ sStaffID +"' ";
                            

                            PreparedStatement ps = XMLcon.con.prepareStatement(sqlDeleteRule);
                            ps.executeUpdate();
                            
                            
                            String sqlDeleteStaff = "DELETE FROM [staff] WHERE staff_id ='"+ sStaffID +"'";
                            ps = XMLcon.con.prepareStatement(sqlDeleteStaff);
                            ps.executeUpdate();
                            
                            JOptionPane.showMessageDialog(null,"Account " +sStaffID+ " is deleted sucessfully");
                            
                        } catch (Exception ex) {
                            ex.getMessage();
                        }

                }else{                    
                    int confirm = JOptionPane.showConfirmDialog(null,"Account '"+sStaffID+"' does not work anymore" ,"Delete", JOptionPane.YES_NO_OPTION);
                    if(confirm == JOptionPane.OK_OPTION){                        
                        try {
                            String supdateStaff_State = "update staff set staff_state = 0 where staff_id = '"+ sStaffID +"' ";
                            PreparedStatement ps = XMLcon.con.prepareStatement(supdateStaff_State);
                            ps.executeUpdate();
                        } catch (SQLException ex) {
                            Logger.getLogger(Main_Screen.class.getName()).log(Level.SEVERE, null, ex);
                        }
                    }else{
                        try {
                            String supdateStaff_State = "update staff set staff_state = 1 where staff_id = '"+ sStaffID +"' ";
                            PreparedStatement ps = XMLcon.con.prepareStatement(supdateStaff_State);
                            ps.executeUpdate();
                        } catch (SQLException ex) {
                            Logger.getLogger(Main_Screen.class.getName()).log(Level.SEVERE, null, ex);
                        }
                    }                    
                }                              
                dem = dem+1;
            }            
        }
        if(dem == 0){
            JOptionPane.showMessageDialog(null, "Please Select row in column (Selection)!");
            
        }else{
            LoginS.showStaffAdmin();
        }
        dem = 0;
    }//GEN-LAST:event_btnDeleteStaffActionPerformed

    public static ArrayList<String> alStaff_id = new ArrayList<>();
//    public static  ArrayList<String> subbject_name = new ArrayList<>();
    public static  ArrayList<String> altech_id = new ArrayList<>();
    private void btnUpdateStaffActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_btnUpdateStaffActionPerformed
        // TODO add your handling code here:
        flag_Staff = "up";
        Create_account ca = new Create_account();
         for ( int i = 0 ; i < tb_staff.getRowCount(); i ++){
            if (tb_staff.getValueAt(i,12) == null) {
//                System.out.println("btnupdate null");
            }else if(tb_staff.getValueAt(i,12) == true){
                ca.setVisible(true);
                String sStaffID = "";
                String sTechnologyName = "";
                sStaffID = tb_staff.getValueAt(i, 0).toString();
                sTechnologyName = tb_staff.getValueAt(i, 11).toString();
                alStaff_id.add(sStaffID);
                altech_id.add(sTechnologyName);
                Create_account.cbStaff_ID.addItem(sStaffID);
                Create_account.txtStaff_id.setVisible(false);
                Label_logo1.setText("Update Account Staff");
//                JOptionPane.showMessageDialog(null,sStaffID);
                dem = dem+1;
            }            
        }
        
//        if(Create_account.cbRule.getSelectedItem().equals("Staff")){
//            String SQL_tech = "Select technology_name From techology";
//            ResultSet rs_tech = ConnClass.getRecordSet(SQL_tech);
//            proPublic.JCompoBoxRecordSet(ca.cbTechnology, rs_tech, 1);
//  
//        }
        
        if(dem == 0){
            JOptionPane.showMessageDialog(null, "Please Select row in column (Selection)!");
            
        }
        dem = 0;
    }//GEN-LAST:event_btnUpdateStaffActionPerformed
// a Bang
     private void TabbedPane_mainMouseClicked(java.awt.event.MouseEvent evt) {                                             
         if(!this.flagStudent){
            this.jPanel6.setVisible(true);
            this.jPanel12.setVisible(false);
            this.panelUpdateStu.setVisible(false);
            panelInforFine.setVisible(true);
            panelDetailFine.setVisible(false);
            //pp.JTableCheckBoxRecordSet(JTable_stu, cc.getRecordSet("select * from student"));            
            this.pp.JCompoBoxRecordSet(jcStuTech, cc.getRecordSet("select * from techology"), 2);
            this.pp.JCompoBoxRecordSet(cbTechFine, cc.getRecordSet("select technology_name from techology"), 1);
            this.pp.JCompoBoxRecordSet(cbTechDetailFine, cc.getRecordSet("select technology_name from techology"), 1);
            this.pp.JCompoBoxRecordSet(cbSemesterFine, cc.getRecordSet("select distinct semester from fine"), 1);
            this.flagStudent = true;
         }         
    }
//     private void jcStuTechActionPerformed(java.awt.event.ActionEvent evt) {                                          
//        String querySQL = "select course_name from course where technology_id in (select technology_id from techology where";
//               querySQL += " technology_name like '" + this.jcStuTech.getSelectedItem() + "')";               
//        if (this.jcStuTech.hasFocus()) {
//            this.jcStuCourse.removeAllItems();
//            this.pp.JCompoBoxRecordSet(this.jcStuCourse, cc.getRecordSet(querySQL), 1);
//            if(this.jcStuClass.getItemAt(0) == null)
//                this.lbTotalStu.setText("No class");
//        } else {
//            this.pp.JCompoBoxRecordSet(this.jcStuCourse, cc.getRecordSet(querySQL), 1);
//        }
//    }
     private void btnInsert3ActionPerformed(java.awt.event.ActionEvent evt) {                                           
        Vector dataInsert = new Vector();
        if (this.tfIDStu3.getText().length() > 10) {
            JOptionPane.showMessageDialog(rootPane, "Id Student have to less then or equal 10 digits");
        } else {
            if (!this.pp.checkDataTypeTextField(tfIDStu3, "String")) {
                JOptionPane.showMessageDialog(rootPane, "ID Student isn't empty and not special characters");
            } else {
                dataInsert.add(this.tfIDStu3.getText());
                if (this.tfPerStu3.getText().length() > 9 || this.tfPerStu3.getText().length() < 9) {
                    JOptionPane.showMessageDialog(rootPane, "Indentity card have 9 digits character");
                } else {
                    if (!this.pp.checkDataTypeTextField(this.tfPerStu3, "Integer")) {
                        JOptionPane.showMessageDialog(rootPane, "Indentity card must to 9 digits character");
                    } else {
                        dataInsert.add(this.tfPerStu3.getText());
                        dataInsert.add(this.cbClassIDStu3.getSelectedItem().toString());
                        if (!this.pp.checkDataTypeTextField(this.tfFirstStu3, "String")) {
                            JOptionPane.showMessageDialog(rootPane, "First name isn't empty and not special characters");
                        } else {
                            dataInsert.add(this.tfFirstStu3.getText());
                            if (!this.pp.checkDataTypeTextField(this.tfLastStu3, "String")) {
                                JOptionPane.showMessageDialog(rootPane, "Last name isn't empty and not special characters");
                            } else {
                                dataInsert.add(this.tfLastStu3.getText());
                                DateFormat dateFormat = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
                                Calendar d = Calendar.getInstance();
                                StringBuilder yearNow = new StringBuilder(dateFormat.format(d.getTime()));
                                int yearSystem = Integer.parseInt(yearNow.delete(4, yearNow.length()).toString());
                                int yearStu = 0;
                                try {
                                    this.pp.covertDate(this.dateBirthdayStu3);
                                    yearStu = Integer.parseInt(this.pp.getYear());
                                } catch (Exception ex) {
                                    JOptionPane.showMessageDialog(rootPane, "Enter year of birth");
                                }
                                if (yearSystem - yearStu < 18 || yearSystem - yearStu > 70) {
                                    JOptionPane.showMessageDialog(rootPane, "Sinh vien co tuoi tu 18 tới 70");
                                } else {
                                    String tempDate = this.pp.getYear() + "-" + this.pp.getMonth() + "-" + this.pp.getDay();
                                    dataInsert.add(tempDate);
                                    dataInsert.add(this.cbGenStu3.getSelectedIndex());
                                    if (this.tfAddStu3.getText().trim().equals("")) {
                                        JOptionPane.showMessageDialog(rootPane, "Address isn't empty");
                                    } else {
                                        dataInsert.add(this.tfAddStu3.getText());
                                        if (this.tfPhoneStu3.getText().trim().equals("")) {
                                            dataInsert.add("NULL");
                                            String strInsert = this.pp.getStringInsertData("student");
                                            Boolean results = this.pp.insertData(strInsert, dataInsert, XMLConfig.con);                                            
                                            if (results) {

                                                this.lbMessage1.setText("You're insert successfully " + count + " record.");
                                                count++;
                                            }
                                        } else {
                                            if (!this.pp.checkInteger(this.tfPhoneStu3) || !(this.tfPhoneStu3.getText().length() == 10)) {
                                                JOptionPane.showMessageDialog(rootPane, "Phone number must to 10 digits character");
                                            } else {
                                                dataInsert.add(this.tfPhoneStu3.getText());
                                                String strInsert = this.pp.getStringInsertData("student");
                                                Boolean results = this.pp.insertData(strInsert, dataInsert, XMLConfig.con);                                                
                                                if (results) {

                                                    this.lbMessage1.setText("You're insert successfully " + count + " record.");
                                                    count++;
                                                }
                                            }
                                        }
                                    }
                                }
                            }
                        }
                    }
                }
            }
        }
    }
     private void btbExitInsert3ActionPerformed(java.awt.event.ActionEvent evt) {                                               
        this.jPanel6.setVisible(true);
        this.jPanel12.setVisible(false);
        ProcessPublic pp = new ProcessPublic();
        pp.JTableCheckBoxRecordSet(this.JTable_stu, cc.getRecordSet("select * from student where class_id like '" + this.jcStuClass.getItemAt(0) + "'"));
        btnUdateStu.setEnabled(true);
        btnDeleteStu.setEnabled(true);
        btnInsertStu.setEnabled(true);
    }
     
    private void jcStuCourse_Update1ItemStateChanged(java.awt.event.ItemEvent evt) {                                                     
        String massage = "";
        if (this.jcStuTech_Update1.hasFocus()) {
            String querySQL = "select * from class where course_id like '" + this.jcStuCourse_Update1.getItemAt(0) + "'";
            //ProcessPublic pp = new ProcessPublic();
            this.jcStuClass_Update1.removeAllItems();
            this.pp.JCompoBoxRecordSet(this.jcStuClass_Update1, this.cc.getRecordSet(querySQL), 2);
            if (this.jcStuClass_Update1.getItemAt(0) == null) {
                this.lbTotalStu1.setText("No class");
            }
        } else {
            String querySQL = "select * from class where course_id like '" + this.jcStuCourse_Update1.getSelectedItem() + "'";
            //ProcessPublic pp = new ProcessPublic();
            if (this.jcStuCourse_Update1.hasFocus()) {
                this.jcStuClass_Update1.removeAllItems();
                this.pp.JCompoBoxRecordSet(this.jcStuClass_Update1, this.cc.getRecordSet(querySQL), 2);
                if (this.jcStuClass_Update1.getItemAt(0) == null) {
                    this.lbTotalStu1.setText("No class");
                }
            } else {
                this.pp.JCompoBoxRecordSet(this.jcStuClass_Update1, this.cc.getRecordSet(querySQL), 2);
            }
        }
    }                                                    

    private void JTableStu_Update1MouseClicked(java.awt.event.MouseEvent evt) {                                               
        int rowSelect = this.JTableStu_Update1.getSelectedRow();
        messageUpdate = true;
        String objectClick = this.JTableStu_Update1.getValueAt(rowSelect, 0).toString();
        this.data = pp.getData(this.cc.getRecordSet("select * from student where student_id like '" + objectClick.toString() + "'"));
        this.lbTotalStu1.setText("");
        if(this.data.elementAt(0).toString().trim().equals("") || this.data.elementAt(0) == null){
            this.tfStuID1.setText("");
        }else{
            this.tfStuID1.setText(data.elementAt(0).toString());
        }
        if(this.data.elementAt(1).toString().trim().equals("") || this.data.elementAt(1) == null){
            this.tfStuIDCard1.setText("");
        }else{
            this.tfStuIDCard1.setText(data.elementAt(1).toString());
        }
        
        this.tfClassIDUpdate.setText(data.elementAt(2).toString());
        
        if(this.data.elementAt(3).toString().trim().equals("") || this.data.elementAt(3) == null){
            this.tfStuFName1.setText("");
        }else{
            this.tfStuFName1.setText(data.elementAt(3).toString());
        }    
        if(this.data.elementAt(4).toString().trim().equals("") || this.data.elementAt(4) == null){
            this.tfStuLName1.setText("");
        }else{
            this.tfStuLName1.setText(data.elementAt(4).toString());
        }    
        
        StringBuilder sbDate = new StringBuilder(data.elementAt(5).toString());        
        String year = "";
        String month = "";
        String day = "";
        if(sbDate.length() == 10){            
            month += sbDate.charAt(5);
            month += sbDate.charAt(6);        
            day += sbDate.charAt(8);
            day += sbDate.charAt(9);
            for (int i = 0; i < 4; i++) {
                year += sbDate.charAt(i);
            }           
        }else{            
            month += sbDate.charAt(5);            
            day += sbDate.charAt(7);
            day += sbDate.charAt(8);
            for (int i = 0; i < 4; i++) {
                year += sbDate.charAt(i);
            }            
        }
        Calendar c = new GregorianCalendar(Integer.parseInt(year), Integer.parseInt(month) - 1, Integer.parseInt(day));
        this.jDateChooserUpdate.setCalendar(c);
        this.jcStuGender1.setSelectedIndex(Integer.parseInt(data.elementAt(6).toString()));
        
        if(this.data.elementAt(7).toString().trim().equals("") || this.data.elementAt(7) == null){
            this.tfStudAdd1.setText("");
        }else{
            this.tfStudAdd1.setText(data.elementAt(7).toString());
        }    
        if(this.data.elementAt(8).toString().trim().equals("") || this.data.elementAt(8) == null){
            this.tfStuPhone1.setText("");
        }else{
            this.tfStuPhone1.setText(data.elementAt(8).toString());
        }   
        
    }                                              

    private void btnCancelUpdateActionPerformed(java.awt.event.ActionEvent evt) {                                                
        this.jPanel6.setVisible(true);
        this.panelUpdateStu.setVisible(false);
        this.jPanel12.setVisible(false);
        btnUdateStu.setEnabled(true);
        btnDeleteStu.setEnabled(true);
        btnInsertStu.setEnabled(true);
    }                                               

    private void jcStuClass_Update1ActionPerformed(java.awt.event.ActionEvent evt) {                                                   
        
        String message = "";
        //ProcessPublic pp = new ProcessPublic();
        String querySQL = "select student_id, student_first_name, student_last_name from student where class_id like '" + this.jcStuClass_Update1.getSelectedItem() + "'";
        this.JTableStu_Update1.removeAll();
        pp.JTableRecordSet(this.JTableStu_Update1, this.cc.getRecordSet(querySQL));
        message = "Class " + this.jcStuClass_Update1.getSelectedItem() + " have " + this.JTableStu_Update1.getRowCount() + " students";
        this.lbTotalStu1.setText(message);
        this.tfStuID1.setText(null);
        this.tfStuIDCard1.setText(null);
        this.tfClassIDUpdate.setText(null);
        this.tfStuFName1.setText(null);
        this.tfStuLName1.setText(null);
        this.jDateChooserUpdate.setDate(null);                
        this.tfStudAdd1.setText(null);
        this.tfStuPhone1.setText(null);
        //this.JTableStu_Update1.setColumnSelectionInterval(0, this.JTableStu_Update1.getRowCount());
    }                                                  

    private void jcStuClass_Update1ItemStateChanged(java.awt.event.ItemEvent evt) {                                                    
        String message = "";
        if (this.jcStuClass_Update1.hasFocus()) {
            //ProcessPublic pp = new ProcessPublic();
            String querySQL = "select student_id, student_first_name, student_last_name from student where class_id like '" + this.jcStuClass_Update1.getItemAt(0) + "'";
            this.JTableStu_Update1.removeAll();
            pp.JTableRecordSet(this.JTableStu_Update1, this.cc.getRecordSet(querySQL));
        } else {            
            String querySQL = "select student_id, student_first_name, student_last_name from student where class_id like '" + this.jcStuClass_Update1.getSelectedItem() + "'";
            ResultSet rs = this.cc.getRecordSet(querySQL);
            this.JTableStu_Update1.removeAll();
            pp.JTableRecordSet(this.JTableStu_Update1, rs);
            if(this.jcStuClass_Update1.getSelectedItem() == null){
                message = "No class";
            }else{
                message = "Class " + this.jcStuClass_Update1.getSelectedItem() + " have " + this.JTableStu_Update1.getRowCount() + " students";
            }
            
            this.lbTotalStu1.setText(message);
        }
        messageUpdate = true;
    }                                                   

    private void tfStuID21KeyPressed(java.awt.event.KeyEvent evt) {                                     
        if (evt.getKeyCode() == 10) {
            String temp = this.tfStuID21.getText();
            if (temp.trim().equals("")) {
                JOptionPane.showMessageDialog(null, "Enter value to find");
            } else {                
                String querySQL = "select student_id, student_first_name, student_last_name from student where student_id like '" + temp + "'";
                this.JTableStu_Update1.removeAll();
                this.pp.JTableCheckBoxRecordSet(this.JTableStu_Update1, cc.getRecordSet(querySQL));
            }
        }
    }                                    

    private void btn_UpdateStu1ActionPerformed(java.awt.event.ActionEvent evt) {                                               
        
        try{
            conditionTemp = this.data.elementAt(0).toString();
            if(!this.tfStuID1.getText().equals(data.elementAt(0).toString()) && !(messageUpdate)){
                if(!pp.checkDataTypeTextField(this.tfStuID1, "String") || this.tfStuID1.getText().length() > 11){
                    JOptionPane.showMessageDialog(rootPane, "Student ID doesn't empty and not special characters and length <= 10");
                }else{                
                    this.data.setElementAt(this.tfStuID1.getText(), 0);
                    messageUpdate = false;                   
                }
            }
            
            if(!this.tfStuIDCard1.getText().equals(this.data.elementAt(1).toString())){
                if(!pp.checkDataTypeTextField(this.tfStuIDCard1, "Integer") || !(this.tfStuIDCard1.getText().length() == 9)){
                    JOptionPane.showMessageDialog(rootPane, "Student ID doesn't empty and not special characters and length = 9");
                }else{
                    this.data.setElementAt(this.tfStuIDCard1.getText(), 1);
                    messageUpdate = false;
                }
            }
            if(!this.tfClassIDUpdate.getText().equals(data.elementAt(2).toString())){
                if(!pp.checkDataTypeTextField(this.tfClassIDUpdate, "String") || (this.tfClassIDUpdate.getText().length() >20)){
                    JOptionPane.showMessageDialog(panel_atten, "Class ID not special character and lenght <= 20");
                }else{
                    ResultSet rs = this.cc.getRecordSet("select class_id from class where class_id like '" + this.tfClassIDUpdate.getText() + "'");
                    rs.next();
                    int i = rs.getRow();            
                    if(i == 0){
                        JOptionPane.showMessageDialog(panel_atten, "Class ID not available");
                    }else{
                        this.data.setElementAt(this.tfClassIDUpdate.getText(), 2);
                        messageUpdate = false;
                    }
                }      
            }
            if(!this.tfStuFName1.getText().equals(data.elementAt(3).toString())){
                if(!pp.checkDataTypeTextField(this.tfStuFName1, "String")){
                    JOptionPane.showMessageDialog(rootPane, "First name doesn't special characters");
                }else{
                    this.data.setElementAt(this.tfStuFName1.getText(), 3);
                    messageUpdate = false;
                }
            }
            
            if(!this.tfStuLName1.getText().equals(data.elementAt(4).toString())){
                if(!pp.checkDataTypeTextField(this.tfStuLName1, "String")){
                    JOptionPane.showMessageDialog(rootPane, "First name doesn't special characters");
                }else{
                    this.data.setElementAt(this.tfStuLName1.getText(), 4);
                    messageUpdate = false;
                }
            }
            
            if(this.jDateChooserUpdate.getDate() == null){
                JOptionPane.showMessageDialog(panel_atten, "Your birthday not empty");
            }else{
                StringBuilder tempDate = new StringBuilder(data.elementAt(5).toString());
                String year = "";
                String month = "";
                String day = "";
                if(tempDate.length() == 10){            
                    month += tempDate.charAt(5);
                    month += tempDate.charAt(6);        
                    day += tempDate.charAt(8);
                    day += tempDate.charAt(9);
                    for (int i = 0; i < 4; i++) {
                        year += tempDate.charAt(i);
                    }           
                }else{            
                    month += tempDate.charAt(5);            
                    day += tempDate.charAt(7);
                    day += tempDate.charAt(8);
                    for (int i = 0; i < 4; i++) {
                        year += tempDate.charAt(i);
                    }
                }
                int yearInt = Integer.parseInt(year);
                int monthInt = Integer.parseInt(month);
                int dayInt = Integer.parseInt(day);
                this.pp.covertDate(this.jDateChooserUpdate);
                int yearNew = Integer.parseInt(this.pp.getYear());
                int monthNew = Integer.parseInt(this.pp.getMonth());
                int dayNew = Integer.parseInt(this.pp.getDay());
                
                if(yearInt != yearNew || monthInt != monthNew || dayInt != dayNew){
                    {
                        DateFormat dateFormat = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
                        Calendar d = Calendar.getInstance();
                        StringBuilder yearNow = new StringBuilder(dateFormat.format(d.getTime()));
                        int yearSystem = Integer.parseInt(yearNow.delete(4, yearNow.length()).toString());
                        if(yearSystem - yearNew < 18 ||yearSystem - yearNew > 70){
                            JOptionPane.showMessageDialog(rootPane, "Sinh vien co tuoi tu 18 tới 70");
                        }else{
                            String tempChoose = yearNew + "-" + monthNew + "-" + dayNew;
                            this.data.setElementAt(tempChoose, 5);
                            messageUpdate = false;
                        }
                    }                   
                }
            }
            if(!(this.jcStuGender1.getSelectedIndex() == Integer.parseInt(this.data.elementAt(6).toString()))){
                this.data.setElementAt(this.jcStuGender1.getSelectedIndex(), 6);
                messageUpdate = false;               
            }           
            if(!this.tfStudAdd1.getText().equals(this.data.elementAt(7).toString())){
                if(!this.pp.checkDataTypeTextField(this.tfStudAdd1, "String") && this.tfStudAdd1.getText().length() < 20){
                    JOptionPane.showMessageDialog(panel_atten, "Your address not special characters and length >= 20");
                }else{
                    this.data.setElementAt(this.tfStudAdd1.getText(), 7);
                    messageUpdate = false;
                }
            }
            if(this.tfStuPhone1.getText().trim().equals("")){
                this.data.setElementAt("Null", 8);
                messageUpdate = false;
            }else{
                if(!this.tfStuPhone1.getText().equals(this.data.elementAt(8).toString())){
                    if(!this.pp.checkDataTypeTextField(tfStuPhone1, "Integer") || !(this.tfStuPhone1.getText().length() == 10)){
                        JOptionPane.showMessageDialog(panel_atten, "Phone number must to digits character and length = 10");
                    }else{
                        this.data.setElementAt(this.tfStuPhone1.getText(), 8);
                        messageUpdate = false;
                    }
                }
            }
            if(messageUpdate == false){
                String strUpdate = this.pp.getStringUpdateData("Student", 0, this.conditionTemp);                
                int result = pp.updateData(strUpdate, this.data, this.cc.con);
                
                if(result > 0){
                    countUpdate += result;
                    this.lbTotalStu1.setText("You're update successfully " + countUpdate + " record");
                }
                String updateFinish = "select student_id, student_first_name, student_last_name from student";
                       updateFinish += " where class_id like '" + this.jcStuClass_Update1.getSelectedItem() + "'"; 
                pp.JTableRecordSet(JTableStu_Update1, cc.getRecordSet(updateFinish));
                this.tfStuID1.setText(null);
                this.tfStuIDCard1.setText(null);
                this.tfClassIDUpdate.setText(null);
                this.tfStuFName1.setText(null);
                this.tfStuLName1.setText(null);
                this.jDateChooserUpdate.setDate(null);                
                this.tfStudAdd1.setText(null);
                this.tfStuPhone1.setText(null);
                messageUpdate = true;
            }else{
                this.lbTotalStu1.setText("Information of this record not changed");
                messageUpdate = true;
            }
        }catch(Exception ex){
            JOptionPane.showMessageDialog(rootPane, "Please, choose record");
        }
    }                                              
    
    private void cbTechDetailFineActionPerformed(java.awt.event.ActionEvent evt) {                                                 
        String querySQL = "select course_name from course where technology_id in (select technology_id from techology where";
               querySQL += " technology_name like '" + this.cbTechDetailFine.getSelectedItem() + "')";               
        if (this.cbTechDetailFine.hasFocus()) {
            this.cbCourseDetailFine.removeAllItems();
            this.pp.JCompoBoxRecordSet(this.cbCourseDetailFine, cc.getRecordSet(querySQL), 1);
            if(this.cbClassDetailFine.getItemAt(0) == null)
                this.messageDetailFine.setText("No class");
        } else {
            this.pp.JCompoBoxRecordSet(this.cbCourseDetailFine, cc.getRecordSet(querySQL), 1);
        }
    }                                                

    private void cbCourseDetailFineItemStateChanged(java.awt.event.ItemEvent evt) {                                                    
        String massage = "";
        if (this.cbTechDetailFine.hasFocus()) {
            String querySQL = "select class_id from class where course_id in (select course_id from "
                            + "course where course_name like '" + this.cbCourseDetailFine.getItemAt(0) + "')";            
            this.cbClassDetailFine.removeAllItems();
            this.pp.JCompoBoxRecordSet(this.cbClassDetailFine, cc.getRecordSet(querySQL), 1);
            if(this.cbClassDetailFine.getItemAt(0) == null)
                this.messageDetailFine.setText("No class");
        } else {
            String querySQL = "select class_id from class where course_id in (select course_id from "
                            + "course where course_name like '" + this.cbCourseDetailFine.getSelectedItem() + "')";            
            if (this.cbCourseDetailFine.hasFocus()) {
                this.cbClassDetailFine.removeAllItems();
                this.pp.JCompoBoxRecordSet(this.cbClassDetailFine, cc.getRecordSet(querySQL), 1);
                if(this.cbClassDetailFine.getItemAt(0) == null)
                this.messageDetailFine.setText("No class");
            } else {
                this.pp.JCompoBoxRecordSet(this.cbClassDetailFine, cc.getRecordSet(querySQL), 1);
            }
        }
    }                                                   

    private void cbClassDetailFineItemStateChanged(java.awt.event.ItemEvent evt) {                                                   
        String message = "";
        String querySQL = "select student.student_id, personal_id, student_first_name + ' ' + student_last_name as 'Full name'"
                        + " from student where student.class_id like '" + cbClassDetailFine.getSelectedItem() + "'";                                                         
        ResultSet rs = cc.getRecordSet(querySQL);
        pp.JTableRecordSet(tableStudentDetailFine, rs);
        message = "Class " + this.cbClassDetailFine.getSelectedItem() + " have " + this.tableStudentDetailFine.getRowCount() + " students";
        this.messageDetailFine.setText(message);
    }                                                  

    private void tfStudentIDDetailFineKeyPressed(java.awt.event.KeyEvent evt) {                                                 
        if(evt.getKeyCode() == 10){
            String querySQL = "select student_id as 'Student id', personal_id as 'Indentity card', student_first_name + ' ' + student_last_name as 'Full name',"
                            + " class_id as 'Class id' from student where student_id like '" + tfStudentIDDetailFine.getText() + "'";                               
            ResultSet rs = cc.getRecordSet(querySQL);
            pp.JTableRecordSet(tableStudentDetailFine, rs);
        }
    }                                                
    
    private void tableStudentDetailFineMouseClicked(java.awt.event.MouseEvent evt) {                                                    
        int rowSelect = tableStudentDetailFine.getSelectedRow();
        String valueChoosed = tableStudentDetailFine.getValueAt(rowSelect, 0).toString();
        String querySQL = "select subject.subject_name as 'Subject name', total_attendance as 'Times attendance' from  Subject join detail_attendance on subject.subject_id = "
                        + "detail_attendance.subject_id where detail_attendance.student_id like '" + valueChoosed + "'";
        pp.JTableRecordSet(tableStudentDetailFine1, cc.getRecordSet(querySQL));
    }                                                   

    private void tableStudentDetailFine1MouseClicked(java.awt.event.MouseEvent evt) {                                                     
        int rowSelect = tableStudentDetailFine1.getSelectedRow();
        String valueChoosed = tableStudentDetailFine1.getValueAt(rowSelect, 0).toString();
        String valueSubjectID = "select subject_id from subject where subject_name like '" + valueChoosed + "'";
        ResultSet rsObjectID = cc.getRecordSet(valueSubjectID);
        Vector dataObjectID = pp.getData(rsObjectID);
        StringBuilder strObjectID = new StringBuilder();
        for(Object s: dataObjectID){
            strObjectID.append("'");
            strObjectID.append(s);
            strObjectID.append("', ");
        }
        strObjectID.deleteCharAt(strObjectID.length() - 2);
        //System.out.println(strObjectID.toString());
        String querySQL = "select class_schedule_time.long as 'Times of the subject', class_schedule_time.starttime as 'Start time', class.start_date "
                        + "as 'Start date', class.end_date as 'End date', detail_attendance.total_attendance as 'Times attendance' from "
                        + "subject join class_schedule_time on subject.subject_id = class_schedule_time.subject_id join class on class.class_id = "
                        + "class_schedule_time.class_id join detail_attendance on detail_attendance.subject_id = subject.subject_id "
                        + "where subject.subject_id in (" + strObjectID.toString() + ")";
        pp.JTableRecordSet(tableStudentDetailFine2, cc.getRecordSet(querySQL));
    }   
    
    private void btnInsertStu(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_btnInsertStu
        this.pp.JCompoBoxRecordSet(this.cbClassIDStu3, cc.getRecordSet("select * from class"), 2);
        this.jPanel6.setVisible(false);
        this.panelUpdateStu.setVisible(false);
        this.jPanel12.setVisible(true);
        btnUdateStu.setEnabled(false);
        btnDeleteStu.setEnabled(false);
        btnInsertStu.setEnabled(false);
   }//GEN-LAST:event_btnInsertStu

    private void btnUdateStuActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_btnUdateStuActionPerformed
        // TODO add your handling code here:
        this.jPanel6.setVisible(false);
        this.panelUpdateStu.setVisible(true);
        this.jPanel12.setVisible(false);
        if(!this.flagStudentUpdate){            
            pp.JTableRecordSet(this.JTableStu_Update1, this.cc.getRecordSet("select student_id, student_first_name, student_last_name from student"));            
            pp.JCompoBoxRecordSet(jcStuTech_Update1, this.cc.getRecordSet("select * from techology"), 1);
            //pp.JCompoBoxRecordSet(this.tf, this.cc.getRecordSet("select class_id from class"), 1);
            this.flagStudentUpdate = true;
        }        
        this.tfStuID1.setText(null);
        this.tfStuIDCard1.setText(null);
        this.tfClassIDUpdate.setText(null);
        this.tfStuFName1.setText(null);
        this.tfStuLName1.setText(null);
        this.jDateChooserUpdate.setDate(null);                
        this.tfStudAdd1.setText(null);
        this.tfStuPhone1.setText(null);
        btnUdateStu.setEnabled(false);
        btnDeleteStu.setEnabled(false);
        btnInsertStu.setEnabled(false);
    }//GEN-LAST:event_btnUdateStuActionPerformed

    private void btnDeleteStuActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_btnDeleteStuActionPerformed
        // TODO add your handling code here:
        int numRecord = this.JTable_stu.getRowCount();
        Vector dataChooser = new Vector();
        String conditionDelete = "";
        for(int i = 0; i < numRecord; i++){
            if(this.JTable_stu.getValueAt(i, 8) == null){
                continue;
            }else{
                if(this.JTable_stu.getValueAt(i, 8).toString().equals("true")){
                    dataChooser.add(this.JTable_stu.getValueAt(i, 0));
                }
            }     
        }
        try{
            StringBuilder sb = new StringBuilder();
            for(Object s : dataChooser){
                sb.append("'");
                sb.append(s.toString());
                sb.append("', ");
            }
            conditionDelete = sb.deleteCharAt(sb.length() - 2).toString().trim();
            
            String strDeleteAtten = "delete from Attendance where student_id in (" + conditionDelete + ")";
            
            String strDeleteAtten_Details = "delete from detail_attendance where student_id in (" + conditionDelete + ")";
            
            String strDeleteFine = "delete from Fine where student_id in (" + conditionDelete + ")";
           
            String strDeleteStu = "delete from Student where student_id in (" + conditionDelete + ")";
            int confirm = JOptionPane.showConfirmDialog(panel_atten, "Are you sure?");
            if(confirm == JOptionPane.OK_OPTION){
                PreparedStatement ps =XMLConfig.con.prepareStatement(strDeleteAtten);
                ps.executeUpdate();

                ps = XMLConfig.con.prepareStatement(strDeleteAtten_Details);
                ps.executeUpdate();

                ps = XMLConfig.con.prepareStatement(strDeleteFine);
                ps.executeUpdate();

                ps = XMLConfig.con.prepareStatement(strDeleteStu);
                int kq = 0;
                kq = ps.executeUpdate();
                if(kq > 0){                    
                    this.JTable_stu.removeAll();                
                    String temp3 = this.jcStuClass.getItemAt(0).toString();
                    String querySQL = "select student_id as 'Student id', personal_id as 'Indentity card', class_id as 'Class ID', student_first_name "
                                    + "+ ' ' + student_last_name as 'Full name', birthday as 'Birthday', gender as 'Gender', address as 'Address', "
                                    + "phone_number as 'Phone number' from student where class_id like '" + temp3 + "'";
                    this.pp.JTableCheckBoxRecordSet(this.JTable_stu, cc.getRecordSet(querySQL));                
                    deletedTotal += kq;
                    //int tempTotal = 0;
                    //tempTotal = this.JTable_stu.getRowCount();
                    //tempTotal = tempTotal - kq;
                    //String message = "Class " + this.jcStuClass.getItemAt(0) + " have " + tempTotal + " students. You're delete " + deletedTotal + " students";
                    String message = "You're delete " + deletedTotal + " students";
                    this.lbTotalStu.setText(message);
                }
            }else{
                if(confirm == JOptionPane.CANCEL_OPTION){                    
                    this.JTable_stu.removeAll();                
                    String temp3 = this.jcStuClass.getItemAt(0).toString();  
                    String querySQL = "select student_id as 'Student id', personal_id as 'Indentity card', class_id as 'Class ID', student_first_name "
                                    + "+ ' ' + student_last_name as 'Full name', birthday as 'Birthday', gender as 'Gender', address as 'Address', "
                                    + "phone_number as 'Phone number' from student where class_id like '" + temp3 + "'";
                    this.pp.JTableCheckBoxRecordSet(this.JTable_stu, cc.getRecordSet(querySQL)); 
                }
            }           
        }catch(Exception ex){
            JOptionPane.showMessageDialog(panel_atten, "Please choose record");
        }
    }//GEN-LAST:event_btnDeleteStuActionPerformed

    private void jcStuTechActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jcStuTechActionPerformed
        // TODO add your handling code here:
        String querySQL = "select * from course where technology_id like '" + this.jcStuTech_Update1.getSelectedItem() + "'";
        //ProcessPublic pp = new ProcessPublic();
        if (this.jcStuTech_Update1.hasFocus()) {
            this.jcStuCourse_Update1.removeAllItems();
            this.pp.JCompoBoxRecordSet(this.jcStuCourse_Update1, this.cc.getRecordSet(querySQL), 1);
            if (this.jcStuClass_Update1.getItemAt(0) == null) {
                this.lbTotalStu1.setText("No class");
            }
        } else {
            this.pp.JCompoBoxRecordSet(this.jcStuCourse_Update1, this.cc.getRecordSet(querySQL), 1);
        }
    }//GEN-LAST:event_jcStuTechActionPerformed

    private void jcStuCourseItemStateChanged(java.awt.event.ItemEvent evt) {//GEN-FIRST:event_jcStuCourseItemStateChanged
        // TODO add your handling code here:
        String massage = "";
        if (this.jcStuTech.hasFocus()) {
            String querySQL = "select class_id from class where course_id in (select course_id from "
                            + "course where course_name like '" + this.jcStuCourse.getItemAt(0) + "')";            
            this.jcStuClass.removeAllItems();
            this.pp.JCompoBoxRecordSet(this.jcStuClass, cc.getRecordSet(querySQL), 1);
            if(this.jcStuClass.getItemAt(0) == null)
                this.lbTotalStu.setText("No class");
        } else {
            String querySQL = "select class_id from class where course_id in (select course_id from "
                            + "course where course_name like '" + this.jcStuCourse.getSelectedItem() + "')";            
            if (this.jcStuCourse.hasFocus()) {
                this.jcStuClass.removeAllItems();
                this.pp.JCompoBoxRecordSet(this.jcStuClass, cc.getRecordSet(querySQL), 1);
                if(this.jcStuClass.getItemAt(0) == null)
                this.lbTotalStu.setText("No class");
            } else {
                this.pp.JCompoBoxRecordSet(this.jcStuClass, cc.getRecordSet(querySQL), 1);
            }
        }
    }//GEN-LAST:event_jcStuCourseItemStateChanged

    private void jcStuClassItemStateChanged(java.awt.event.ItemEvent evt) {//GEN-FIRST:event_jcStuClassItemStateChanged
        // TODO add your handling code here:
        String message = "";
        if (this.jcStuClass.hasFocus()) {            
            String querySQL = "select * from student where class_id like '" + this.jcStuClass.getItemAt(0) + "'";
            this.JTable_stu.removeAll();
            this.pp.JTableCheckBoxRecordSet(this.JTable_stu, cc.getRecordSet(querySQL));
        } else {            
            String querySQL = "select * from student where class_id like '" + this.jcStuClass.getSelectedItem() + "'";
            ResultSet rs = cc.getRecordSet(querySQL);
            this.JTable_stu.removeAll();
            this.pp.JTableCheckBoxRecordSet(this.JTable_stu, rs);
            if(this.jcStuClass.getSelectedItem() == null){
                message = "No class";
            }else{
                message = "Class " + this.jcStuClass.getSelectedItem() + " have " + this.JTable_stu.getRowCount() + " students";
            }
            
            this.lbTotalStu.setText(message);
        }
    }//GEN-LAST:event_jcStuClassItemStateChanged

    private void jcStuClassActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jcStuClassActionPerformed
        // TODO add your handling code here:
        String message = "";        
        String querySQL = "select student_id as 'Student id', personal_id as 'Indentity card', class_id as 'Class ID', student_first_name "
                        + "+ ' ' + student_last_name as 'Full name', birthday as 'Birthday', gender as 'Gender', address as 'Address', "
                        + "phone_number as 'Phone number' from student where class_id like '" + this.jcStuClass.getSelectedItem() + "'";
        this.JTable_stu.removeAll();
        this.pp.JTableCheckBoxRecordSet(this.JTable_stu, cc.getRecordSet(querySQL));
        message = "Class " + this.jcStuClass.getSelectedItem() + " have " + this.JTable_stu.getRowCount() + " students";
        this.lbTotalStu.setText(message);
    }//GEN-LAST:event_jcStuClassActionPerformed

    private void tfStuIDKeyPressed(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_tfStuIDKeyPressed
        // TODO add your handling code here:
        if (evt.getKeyCode() == 10) {
            String temp = this.tfStuID.getText();
            if (temp.trim().equals("")) {
                JOptionPane.showMessageDialog(null, "Enter value to find");
            } else {                
                String querySQL = "select student_id as 'Student id', personal_id as 'Indentity card', class_id as 'Class ID', student_first_name "
                                + "+ ' ' + student_last_name as 'Full name', birthday as 'Birthday', gender as 'Gender', address as 'Address', "
                                + "phone_number as 'Phone number' from student where student_id like '" + temp + "'";
                this.JTable_stu.removeAll();
                this.pp.JTableCheckBoxRecordSet(this.JTable_stu, cc.getRecordSet(querySQL));
            }
        }
    }//GEN-LAST:event_tfStuIDKeyPressed

    private void btnDetailFineActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_btnDetailFineActionPerformed
        // TODO add your handling code here:
        if(btnDetailFine.getText().equals("Detail fine of the student")){
            panelInforFine.setVisible(false);
            panelDetailFine.setVisible(true);
            btnDetailFine.setText("Back to information fine");
        }else{
            panelInforFine.setVisible(true);
            panelDetailFine.setVisible(false);
            btnDetailFine.setText("Detail fine of the student");
        }
    }//GEN-LAST:event_btnDetailFineActionPerformed

    private void cbTechFineActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_cbTechFineActionPerformed
        // TODO add your handling code here:
        String querySQL = "select course_name from course where technology_id in (select technology_id from techology where";
               querySQL += " technology_name like '" + this.cbTechFine.getSelectedItem() + "')";               
        if (this.cbTechFine.hasFocus()) {
            this.cbCourseFine.removeAllItems();
            this.pp.JCompoBoxRecordSet(this.cbCourseFine, cc.getRecordSet(querySQL), 1);
            if(this.cbClassFine.getItemAt(0) == null)
                this.messageFine.setText("No class");
        } else {
            this.pp.JCompoBoxRecordSet(this.cbCourseFine, cc.getRecordSet(querySQL), 1);
        }
    }//GEN-LAST:event_cbTechFineActionPerformed

    private void cbCourseFineItemStateChanged(java.awt.event.ItemEvent evt) {//GEN-FIRST:event_cbCourseFineItemStateChanged
        // TODO add your handling code here:
        String massage = "";
        if (this.cbTechFine.hasFocus()) {
            String querySQL = "select class_id from class where course_id in (select course_id from "
                            + "course where course_name like '" + this.cbCourseFine.getItemAt(0) + "')";            
            this.cbClassFine.removeAllItems();
            this.pp.JCompoBoxRecordSet(this.cbClassFine, cc.getRecordSet(querySQL), 1);
            if(this.cbClassFine.getItemAt(0) == null)
                this.messageFine.setText("No class");
        } else {
            String querySQL = "select class_id from class where course_id in (select course_id from "
                            + "course where course_name like '" + this.cbCourseFine.getSelectedItem() + "')";            
            if (this.cbCourseFine.hasFocus()) {
                this.cbClassFine.removeAllItems();
                this.pp.JCompoBoxRecordSet(this.cbClassFine, cc.getRecordSet(querySQL), 1);
                if(this.cbClassFine.getItemAt(0) == null)
                this.messageFine.setText("No class");
            } else {
                this.pp.JCompoBoxRecordSet(this.cbClassFine, cc.getRecordSet(querySQL), 1);
            }
        }
    }//GEN-LAST:event_cbCourseFineItemStateChanged

    private void cbClassFineItemStateChanged(java.awt.event.ItemEvent evt) {//GEN-FIRST:event_cbClassFineItemStateChanged
        // TODO add your handling code here:
        if(cbSemesterFine.getSelectedItem() != null){
            String querySQL = "select student.student_id, personal_id, student_first_name + ' ' + student_last_name as 'Full name',"
                            + " class_id, [S/y] as 'Total time attended in the semster', total_fine as 'Fines', status as 'Paid or Not'"
                            + " from student join fine on student.student_id = fine.student_id where student.class_id like '" 
                            + cbClassFine.getSelectedItem() +"' and fine.semester = " + cbSemesterFine.getSelectedItem();
                            //+  " and fine.student_id like '" + tfStudentIDFine.getText() + "'";                               
            ResultSet rs = cc.getRecordSet(querySQL);
            pp.JTableRecordSet(tableFine, rs);
        }
    }//GEN-LAST:event_cbClassFineItemStateChanged

    private void cbSemesterFineActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_cbSemesterFineActionPerformed
        // TODO add your handling code here:
        if(cbClassFine.getSelectedItem() == null && tfStudentIDFine.getText().trim().equals("")){
            JOptionPane.showMessageDialog(panel_atten, "You're enter student id or class id, please");            
        }else{
            if(cbClassFine.getSelectedItem() == null){
                String querySQL = "select student.student_id, personal_id, student_first_name + ' ' + student_last_name as 'Full name',"
                                + " class_id, [S/y] as 'Total time attended in the semster', total_fine as 'Fines', status as 'Paid or Not'"
                                + " from student join fine on student.student_id = fine.student_id where fine.semester = " 
                                + cbSemesterFine.getSelectedItem() +" and fine.student_id like '" + tfStudentIDFine.getText() + "'";                               
                ResultSet rs = cc.getRecordSet(querySQL);
                pp.JTableRecordSet(tableFine, rs);
            }else{
                String querySQL = "select student.student_id, personal_id, student_first_name + ' ' + student_last_name as 'Full name',"
                                + " class_id, [S/y] as 'Total time attended in the semster', total_fine as 'Fines', status as 'Paid or Not'"
                                + " from student join fine on student.student_id = fine.student_id where fine.semester = " 
                                + cbSemesterFine.getSelectedItem() +" and fine.student_id in(select student_id from student where class_id like '"
                                + cbClassFine.getSelectedItem() + "')";                                
                ResultSet rs = cc.getRecordSet(querySQL);
                pp.JTableRecordSet(tableFine, rs);
            }
        }
    }//GEN-LAST:event_cbSemesterFineActionPerformed

    private void tfStudentIDFineKeyPressed(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_tfStudentIDFineKeyPressed
        // TODO add your handling code here:
        if(evt.getKeyCode() == 10){
            String querySQL = "select student.student_id, personal_id, student_first_name + ' ' + student_last_name as 'Full name',"
                                + " class_id, fine.semester, [S/y] as 'Total time attended in the semster', total_fine as 'Fines',"
                                + " status as 'Paid or Not' from student join fine on student.student_id = fine.student_id where"
                                + " fine.student_id like '" + tfStudentIDFine.getText() + "'";                               
                ResultSet rs = cc.getRecordSet(querySQL);
                pp.JTableRecordSet(tableFine, rs);
        }
    }//GEN-LAST:event_tfStudentIDFineKeyPressed
    public static void main(String args[]) {


//        //Minh connection
//        Config Con = new Config();
//        System.out.println(Con.initConnection());
//        // end Minh connection







        //<editor-fold defaultstate="collapsed" desc=" Look and feel setting code (optional) ">
        /*
         * If Nimbus (introduced in Java SE 6) is not available, stay with the
         * default look and feel. For details see
         * http://download.oracle.com/javase/tutorial/uiswing/lookandfeel/plaf.html
         */
        try {
            for (javax.swing.UIManager.LookAndFeelInfo info : javax.swing.UIManager.getInstalledLookAndFeels()) {
                if ("Nimbus".equals(info.getName())) {
                    javax.swing.UIManager.setLookAndFeel(info.getClassName());
                    break;
                }
            }
        } catch (ClassNotFoundException ex) {
            java.util.logging.Logger.getLogger(Main_Screen.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
        } catch (InstantiationException ex) {
            java.util.logging.Logger.getLogger(Main_Screen.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
        } catch (IllegalAccessException ex) {
            java.util.logging.Logger.getLogger(Main_Screen.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
        } catch (javax.swing.UnsupportedLookAndFeelException ex) {
            java.util.logging.Logger.getLogger(Main_Screen.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
        }
        //</editor-fold>

        java.awt.EventQueue.invokeLater(new Runnable() {

            public void run() {
                new Main_Screen().setVisible(true);
                

            }
        });
    }
    
//    public static javax.swing.JTextField txtLoginUser;

    // Variables declaration - do not modify//GEN-BEGIN:variables
    private javax.swing.JTable JTable_stu;
    private javax.swing.JLabel Label_logo;
    private javax.swing.JLabel Label_logo1;
    private javax.swing.JLabel Label_logo10;
    private javax.swing.JLabel Label_logo2;
    private javax.swing.JLabel Label_logo3;
    private javax.swing.JLabel Label_logo4;
    private javax.swing.JLabel Label_logo5;
    private javax.swing.JLabel Label_logo6;
    private javax.swing.JLabel Label_logo8;
    private javax.swing.JLabel Label_logo9;
    private javax.swing.JPanel Panel_logo;
    private javax.swing.JPanel Panel_logo1;
    public static javax.swing.JTabbedPane TabbedPane_main;
    private javax.swing.JTabbedPane Tabbed_technology;
    public static javax.swing.JButton btnConfigSQL;
    private javax.swing.JButton btnDeleteStaff;
    private javax.swing.JButton btnDeleteStu;
    private javax.swing.JButton btnDetailFine;
    private javax.swing.JButton btnInsertStu;
    public static javax.swing.JButton btnLoginCancel;
    public static javax.swing.JButton btnLoginUser;
    private javax.swing.JButton btnUdateStu;
    private javax.swing.JButton btnUpdateStaff;
    public static javax.swing.JButton btn_create_new_acc;
    private javax.swing.JComboBox cbClassFine;
    private javax.swing.JComboBox cbCourseFine;
    private javax.swing.JComboBox cbSemesterFine;
    private javax.swing.JComboBox cbTechFine;
    private javax.swing.JButton jButton10;
    private javax.swing.JButton jButton13;
    private javax.swing.JButton jButton14;
    private javax.swing.JButton jButton15;
    private javax.swing.JButton jButton16;
    private javax.swing.JButton jButton17;
    private javax.swing.JButton jButton18;
    private javax.swing.JButton jButton19;
    private javax.swing.JButton jButton20;
    private javax.swing.JButton jButton21;
    private javax.swing.JButton jButton22;
    private javax.swing.JButton jButton23;
    private javax.swing.JButton jButton24;
    private javax.swing.JButton jButton25;
    private javax.swing.JButton jButton29;
    private javax.swing.JButton jButton3;
    private javax.swing.JButton jButton30;
    private javax.swing.JButton jButton31;
    private javax.swing.JButton jButton32;
    private javax.swing.JButton jButton36;
    private javax.swing.JButton jButton37;
    private javax.swing.JButton jButton4;
    private javax.swing.JButton jButton5;
    private javax.swing.JButton jButton6;
    private javax.swing.JButton jButton7;
    private javax.swing.JButton jButton8;
    private javax.swing.JButton jButton9;
    private javax.swing.JComboBox jComboBox1;
    private javax.swing.JComboBox jComboBox2;
    private javax.swing.JComboBox jComboBox3;
    private javax.swing.JComboBox jComboBox4;
    private javax.swing.JComboBox jComboBox5;
    private javax.swing.JComboBox jComboBox6;
    private javax.swing.JComboBox jComboBox7;
    private javax.swing.JComboBox jComboBox8;
    private javax.swing.JComboBox jComboBox9;
    private javax.swing.JLabel jLabel10;
    private javax.swing.JLabel jLabel11;
    private javax.swing.JLabel jLabel12;
    private javax.swing.JLabel jLabel13;
    private javax.swing.JLabel jLabel14;
    private javax.swing.JLabel jLabel15;
    private javax.swing.JLabel jLabel16;
    private javax.swing.JLabel jLabel17;
    private javax.swing.JLabel jLabel18;
    private javax.swing.JLabel jLabel19;
    private javax.swing.JLabel jLabel20;
    private javax.swing.JLabel jLabel21;
    private javax.swing.JLabel jLabel22;
    private javax.swing.JLabel jLabel23;
    private javax.swing.JLabel jLabel24;
    private javax.swing.JLabel jLabel25;
    private javax.swing.JLabel jLabel26;
    private javax.swing.JLabel jLabel27;
    private javax.swing.JLabel jLabel28;
    private javax.swing.JLabel jLabel29;
    private javax.swing.JLabel jLabel4;
    private javax.swing.JLabel jLabel5;
    private javax.swing.JLabel jLabel6;
    private javax.swing.JLabel jLabel7;
    private javax.swing.JLabel jLabel8;
    private javax.swing.JLabel jLabel9;
    private javax.swing.JLayeredPane jLayeredPane1;
    private javax.swing.JLayeredPane jLayeredPane10;
    private javax.swing.JLayeredPane jLayeredPane11;
    private javax.swing.JLayeredPane jLayeredPane12;
    private javax.swing.JLayeredPane jLayeredPane13;
    private javax.swing.JLayeredPane jLayeredPane2;
    private javax.swing.JLayeredPane jLayeredPane3;
    private javax.swing.JLayeredPane jLayeredPane4;
    private javax.swing.JLayeredPane jLayeredPane5;
    private javax.swing.JLayeredPane jLayeredPane6;
    private javax.swing.JLayeredPane jLayeredPane7;
    private javax.swing.JLayeredPane jLayeredPane8;
    private javax.swing.JLayeredPane jLayeredPane9;
    private javax.swing.JPanel jPanel10;
    private javax.swing.JPanel jPanel11;
    private javax.swing.JPanel jPanel2;
    private javax.swing.JPanel jPanel3;
    private javax.swing.JPanel jPanel4;
    private javax.swing.JPanel jPanel5;
    private javax.swing.JPanel jPanel6;
    private javax.swing.JPanel jPanel7;
    private javax.swing.JPanel jPanel8;
    private javax.swing.JPanel jPanel9;
    private javax.swing.JPanel jPanelLogin;
    private javax.swing.JScrollPane jScrollPane1;
    private javax.swing.JScrollPane jScrollPane10;
    private javax.swing.JScrollPane jScrollPane2;
    private javax.swing.JScrollPane jScrollPane3;
    private javax.swing.JScrollPane jScrollPane4;
    private javax.swing.JScrollPane jScrollPane5;
    private javax.swing.JScrollPane jScrollPane6;
    private javax.swing.JScrollPane jScrollPane7;
    private javax.swing.JScrollPane jScrollPane8;
    private javax.swing.JScrollPane jScrollPane9;
    private javax.swing.JTable jTable1;
    private javax.swing.JTable jTable2;
    private javax.swing.JTable jTable3;
    private javax.swing.JTable jTable4;
    private javax.swing.JTable jTable6;
    private javax.swing.JTable jTable7;
    private javax.swing.JTable jTable9;
    private javax.swing.JTextField jTextField3;
    private javax.swing.JTextField jTextField4;
    private javax.swing.JTextField jTextField6;
    private javax.swing.JTextField jTextField7;
    private javax.swing.JComboBox jcStuClass;
    private javax.swing.JComboBox jcStuCourse;
    private javax.swing.JComboBox jcStuTech;
    private javax.swing.JLabel lbTotalStu;
    private javax.swing.JLabel messageFine;
    private javax.swing.JPanel panelInforFine;
    private javax.swing.JPanel panel_atten;
    private javax.swing.JPanel ps;
    private javax.swing.JTabbedPane tabbed_class;
    private javax.swing.JTable tableFine;
    public static javax.swing.JTable tb_staff;
    private javax.swing.JTextField tfStuID;
    private javax.swing.JTextField tfStudentIDFine;
    public static javax.swing.JPasswordField txtLoginPass;
    public static javax.swing.JTextField txtLoginUser;
    // End of variables declaration//GEN-END:variables
//    a Bang
    private javax.swing.JTable JTableStu_Update1;
//    private javax.swing.JTable JTable_stu;
    private javax.swing.JLabel LabelUpdate;
//    private javax.swing.JLabel Label_logo;
//    private javax.swing.JLabel Label_logo1;
//    private javax.swing.JLabel Label_logo10;
    private javax.swing.JLabel Label_logo11;
    private javax.swing.JLabel Label_logo12;
//    private javax.swing.JLabel Label_logo2;
//    private javax.swing.JLabel Label_logo3;
//    private javax.swing.JLabel Label_logo4;
//    private javax.swing.JLabel Label_logo5;
//    private javax.swing.JLabel Label_logo6;
//    private javax.swing.JLabel Label_logo8;
//    private javax.swing.JLabel Label_logo9;
//    private javax.swing.JPanel Panel_logo;
//    private javax.swing.JPanel Panel_logo1;
//    public static javax.swing.JTabbedPane TabbedPane_main;
//    private javax.swing.JTabbedPane Tabbed_technology;
    private javax.swing.JButton btbExitInsert3;
    private javax.swing.JButton btnCancelUpdate;
//    public static javax.swing.JButton btnConfigSQL;
//    private javax.swing.JButton btnDeleteStu;
//    private javax.swing.JButton btnDetailFine;
    private javax.swing.JButton btnInsert3;
//    private javax.swing.JButton btnInsertStu;
//    public static javax.swing.JButton btnLoginCancel;
//    public static javax.swing.JButton btnLoginUser;
//    private javax.swing.JButton btnUdateStu;
    private javax.swing.JButton btn_UpdateStu1;
    private javax.swing.JComboBox cbClassDetailFine;
//    private javax.swing.JComboBox cbClassFine;
    private javax.swing.JComboBox cbClassIDStu3;
    private javax.swing.JComboBox cbCourseDetailFine;
//    private javax.swing.JComboBox cbCourseFine;
    private javax.swing.JComboBox cbGenStu3;
//    private javax.swing.JComboBox cbSemesterFine;
    private javax.swing.JComboBox cbTechDetailFine;
//    private javax.swing.JComboBox cbTechFine;
    private com.toedter.calendar.JDateChooser dateBirthdayStu3;
//    private javax.swing.JButton jButton10;
    private javax.swing.JButton jButton11;
    private javax.swing.JButton jButton12;
//    private javax.swing.JButton jButton13;
//    private javax.swing.JButton jButton14;
//    private javax.swing.JButton jButton15;
//    private javax.swing.JButton jButton16;
//    private javax.swing.JButton jButton17;
//    private javax.swing.JButton jButton18;
//    private javax.swing.JButton jButton19;
//    private javax.swing.JButton jButton20;
//    private javax.swing.JButton jButton21;
//    private javax.swing.JButton jButton22;
//    private javax.swing.JButton jButton23;
//    private javax.swing.JButton jButton24;
//    private javax.swing.JButton jButton25;
//    private javax.swing.JButton jButton29;
//    private javax.swing.JButton jButton3;
//    private javax.swing.JButton jButton30;
//    private javax.swing.JButton jButton31;
//    private javax.swing.JButton jButton32;
//    private javax.swing.JButton jButton35;
//    private javax.swing.JButton jButton36;
//    private javax.swing.JButton jButton37;
//    private javax.swing.JButton jButton4;
//    private javax.swing.JButton jButton5;
//    private javax.swing.JButton jButton6;
//    private javax.swing.JButton jButton7;
//    private javax.swing.JButton jButton8;
//    private javax.swing.JButton jButton9;
//    private javax.swing.JComboBox jComboBox1;
//    private javax.swing.JComboBox jComboBox2;
//    private javax.swing.JComboBox jComboBox3;
//    private javax.swing.JComboBox jComboBox4;
//    private javax.swing.JComboBox jComboBox5;
//    private javax.swing.JComboBox jComboBox6;
//    private javax.swing.JComboBox jComboBox7;
//    private javax.swing.JComboBox jComboBox8;
//    private javax.swing.JComboBox jComboBox9;
    private com.toedter.calendar.JDateChooser jDateChooserUpdate;
    private javax.swing.JLabel jLabel1;
//    private javax.swing.JLabel jLabel10;
//    private javax.swing.JLabel jLabel11;
//    private javax.swing.JLabel jLabel12;
//    private javax.swing.JLabel jLabel13;
//    private javax.swing.JLabel jLabel14;
//    private javax.swing.JLabel jLabel15;
//    private javax.swing.JLabel jLabel16;
//    private javax.swing.JLabel jLabel17;
//    private javax.swing.JLabel jLabel18;
//    private javax.swing.JLabel jLabel19;
    private javax.swing.JLabel jLabel2;
//    private javax.swing.JLabel jLabel20;
//    private javax.swing.JLabel jLabel21;
//    private javax.swing.JLabel jLabel22;
//    private javax.swing.JLabel jLabel23;
//    private javax.swing.JLabel jLabel24;
//    private javax.swing.JLabel jLabel25;
//    private javax.swing.JLabel jLabel26;
//    private javax.swing.JLabel jLabel27;
//    private javax.swing.JLabel jLabel28;
//    private javax.swing.JLabel jLabel29;
    private javax.swing.JLabel jLabel3;
    private javax.swing.JLabel jLabel30;
    private javax.swing.JLabel jLabel31;
    private javax.swing.JLabel jLabel32;
    private javax.swing.JLabel jLabel33;
    private javax.swing.JLabel jLabel34;
    private javax.swing.JLabel jLabel39;
//    private javax.swing.JLabel jLabel4;
    private javax.swing.JLabel jLabel40;
    private javax.swing.JLabel jLabel41;
    private javax.swing.JLabel jLabel42;
    private javax.swing.JLabel jLabel43;
    private javax.swing.JLabel jLabel44;
    private javax.swing.JLabel jLabel45;
    private javax.swing.JLabel jLabel46;
    private javax.swing.JLabel jLabel47;
    private javax.swing.JLabel jLabel48;
    private javax.swing.JLabel jLabel49;
//    private javax.swing.JLabel jLabel5;
    private javax.swing.JLabel jLabel50;
    private javax.swing.JLabel jLabel51;
    private javax.swing.JLabel jLabel52;
    private javax.swing.JLabel jLabel53;
    private javax.swing.JLabel jLabel54;
    private javax.swing.JLabel jLabel55;
//    private javax.swing.JLabel jLabel6;
//    private javax.swing.JLabel jLabel7;
//    private javax.swing.JLabel jLabel8;
//    private javax.swing.JLabel jLabel9;
//    private javax.swing.JLayeredPane jLayeredPane1;
//    private javax.swing.JLayeredPane jLayeredPane10;
//    private javax.swing.JLayeredPane jLayeredPane11;
//    private javax.swing.JLayeredPane jLayeredPane12;
//    private javax.swing.JLayeredPane jLayeredPane13;
    private javax.swing.JLayeredPane jLayeredPane14;
//    private javax.swing.JLayeredPane jLayeredPane2;
//    private javax.swing.JLayeredPane jLayeredPane3;
//    private javax.swing.JLayeredPane jLayeredPane4;
//    private javax.swing.JLayeredPane jLayeredPane5;
//    private javax.swing.JLayeredPane jLayeredPane6;
//    private javax.swing.JLayeredPane jLayeredPane7;
//    private javax.swing.JLayeredPane jLayeredPane8;
//    private javax.swing.JLayeredPane jLayeredPane9;
    private javax.swing.JPanel jPanel1;
//    private javax.swing.JPanel jPanel10;
//    private javax.swing.JPanel jPanel11;
    private javax.swing.JPanel jPanel12;
//    private javax.swing.JPanel jPanel2;
//    private javax.swing.JPanel jPanel3;
//    private javax.swing.JPanel jPanel4;
//    private javax.swing.JPanel jPanel5;
//    private javax.swing.JPanel jPanel6;
//    private javax.swing.JPanel jPanel7;
//    private javax.swing.JPanel jPanel8;
//    private javax.swing.JPanel jPanel9;
//    private javax.swing.JScrollPane jScrollPane1;
//    private javax.swing.JScrollPane jScrollPane10;
    private javax.swing.JScrollPane jScrollPane11;
    private javax.swing.JScrollPane jScrollPane12;
    private javax.swing.JScrollPane jScrollPane13;
    private javax.swing.JScrollPane jScrollPane14;
//    private javax.swing.JScrollPane jScrollPane2;
//    private javax.swing.JScrollPane jScrollPane3;
//    private javax.swing.JScrollPane jScrollPane4;
//    private javax.swing.JScrollPane jScrollPane5;
//    private javax.swing.JScrollPane jScrollPane6;
//    private javax.swing.JScrollPane jScrollPane7;
//    private javax.swing.JScrollPane jScrollPane8;
//    private javax.swing.JScrollPane jScrollPane9;
//    private javax.swing.JTable jTable1;
//    private javax.swing.JTable jTable2;
//    private javax.swing.JTable jTable3;
//    private javax.swing.JTable jTable4;
//    private javax.swing.JTable jTable6;
//    private javax.swing.JTable jTable7;
//    private javax.swing.JTable jTable9;
//    private javax.swing.JTextField jTextField3;
//    private javax.swing.JTextField jTextField4;
//    private javax.swing.JTextField jTextField6;
//    private javax.swing.JTextField jTextField7;
//    private javax.swing.JComboBox jcStuClass;
    private javax.swing.JComboBox jcStuClass_Update1;
//    private javax.swing.JComboBox jcStuCourse;
    private javax.swing.JComboBox jcStuCourse_Update1;
    private javax.swing.JComboBox jcStuGender1;
//    private javax.swing.JComboBox jcStuTech;
    private javax.swing.JComboBox jcStuTech_Update1;
    private javax.swing.JLabel lbMessage1;
//    private javax.swing.JLabel lbTotalStu;
    private javax.swing.JLabel lbTotalStu1;
    private javax.swing.JLabel lbUpdateTechID;
    private javax.swing.JLabel messageDetailFine;
//    private javax.swing.JLabel messageFine;
    private javax.swing.JPanel panelDetailFine;
//    private javax.swing.JPanel panelInforFine;
    private javax.swing.JPanel panelUpdateStu;
//    private javax.swing.JPanel panel_atten;
//    private javax.swing.JPanel ps;
//    private javax.swing.JTabbedPane tabbed_class;
//    private javax.swing.JTable tableFine;
    private javax.swing.JTable tableStudentDetailFine;
    private javax.swing.JTable tableStudentDetailFine1;
    private javax.swing.JTable tableStudentDetailFine2;
//    public static javax.swing.JTable tb_staff;
    private javax.swing.JTextField tfAddStu3;
    private javax.swing.JTextField tfClassIDUpdate;
    private javax.swing.JTextField tfFirstStu3;
    private javax.swing.JTextField tfIDStu3;
    private javax.swing.JTextField tfLastStu3;
    private javax.swing.JTextField tfPerStu3;
    private javax.swing.JTextField tfPhoneStu3;
    private javax.swing.JTextField tfStuFName1;
//    private javax.swing.JTextField tfStuID;
    private javax.swing.JTextField tfStuID1;
    private javax.swing.JTextField tfStuID21;
    private javax.swing.JTextField tfStuIDCard1;
    private javax.swing.JTextField tfStuLName1;
    private javax.swing.JTextField tfStuPhone1;
    private javax.swing.JTextField tfStudAdd1;
    private javax.swing.JTextField tfStudentIDDetailFine;
//    private javax.swing.JTextField tfStudentIDFine;
//    public static javax.swing.JPasswordField txtLoginPass;
//    public static javax.swing.JTextField txtLoginUser;
    
//    end a Bang
    private JDateChooser date_sche;
    private JDateChooser date_atten;
}
